三表联合查询

    use bishe_jxc;
    
    #用户和购票表为主表，购票细节表为子表
    
    #创建用户表
    create table user_jxc(
    uId_jxc int not null auto_increment,
    uName_jxc varchar(16)  not null,
    uPwd_jxc varchar(16) not null,
    uSex_jxc varchar(4) not null,
    uTelp_jxc varchar(11) not null,
    primary key(uId_jxc)
    )engine=InnoDB auto_increment =1;
    
    #创建购票表
    create  table order_jxc(
    orderId_jxc int not null auto_increment,
    tickDate_jxc varchar(50) not null,
    fabuer varchar(10) not null,
    primary key(orderId_jxc)
    )engine=InnoDB auto_increment =10;
    
    #创建订单细节表a
    create