sql语句怎么写
想以表b的某个条件查询表a数据
A
id name userid class
B
id userid chengji
与B的chengji为条件查询 A 的数据
[解决办法]
chengji int 型:
select A.* from A,B where A.userid=B.userid and chengji=XXXX
chengji varchar 型:
select A.* from A,B where A.userid=B.userid and chengji= 'XXXX '
[解决办法]
up
[解决办法]
1楼正解
