Home
Sign Up
Sign In
V2EX
›
问与答
求一条SQL,两表取值的,是不是要用子查询?
icerunz
·
Feb 15, 2012
· 4358 views
This topic created in 5380 days ago, the information mentioned may be changed or developed.
需求是要从table1查出id1,然后从table2中根据id1查出对应的id2。
表的大概结构就是:
table1的字段:
id_ai,id1,name1,desc1
table2的字段:
id_ai,id1,id2
这样的需求能够用一句SQL就搞定么?
谢谢。
id1
table2
table1
3 replies
•
1970-01-01 08:00:00 +08:00
ri0day
Feb 15, 2012
1
join 也可以吧
reus
Feb 15, 2012 via Android
2
select id2 from table1 left join table2 on table1.id1=table2.id1 where ....
这样吧
icerunz
OP
Feb 15, 2012
3
@
reus
感谢,通了。:)
About
·
Help
·
Advertise
·
Blog
·
API
·
FAQ
·
Privacy
·
Solana
·
523 Online
Highest 6679
·
Select Language
创意工作者们的社区
World is powered by solitude
VERSION: 3.9.8.5 · 29ms ·
UTC 20:01
·
PVG 04:01
·
LAX 12:01
·
JFK 15:01
♥ Do have faith in what you're doing.
❯