问题

[ldk]

A表：
字段：ID,title
1,'测试一'
2,'测试二'
3,'测试三'
B表：
字段：ID,user
1,'zg'
1,'ct'
2,'zg'
2,'sss'
3,'owp'
B表的ID字段值是从A表的ID中取的。
请问我如何找到符合条件"user='zg'"的title？

[psxfghost]

select A.title from A left join B on A.ID=B.ID where B.user='zg'

or

select A.title from A,B where A.ID=B.ID and B.user='zg'

[愉快的登山者]

select title from B left join A on A.id = B.id and B.user = 'zg'

[cjt000000]

select title from a where id=(select id from b where usrer ='zg')

[pengdali]

select * from a表 where id in (select id from b表 where user='zg')