mysql复合查询

select orders.cust_name,count(订单表.odd_price) from orders,orders_line,订单表 where orders.cust_name = 订单表.ord_custome and 订单表.odr_id = orders_line.odd_order_id group by orders.cust_name

不可能，帮你试过了，没错。

drop table student_teacher

create table student_teacher

(

student_id varchar(8) not null,

teacher_id varchar(8) not null,

ischecked int not null,

constraint pk_student_teacher primary key(student_id,teacher_id)

)

go

insert into student_teacher values('2001', 'T001',1)

insert into student_teacher values('2002', 'T001',0)

insert into student_teacher values('2002', 'T002',1)

insert into student_teacher values('2001', 'T002',0)

go

select * from student_teacher

go

---