nested SQL help! - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

nested SQL help!

nested SQL help!# Database - 数据库

h*r2001-01-29 08:01

1 楼

can I use only one SQl sentence to select an item from
multiple table?
like,
select item1 from /* here should be another SQL sentence to
get
all tablename I want to search item1 */
where item1 like 'something';
or at lease can be:
select item1 from Tab1, Tab2 where item1 like 'something".
Thanks a lot for help.

p*e2001-01-29 08:01

2 楼

sure.
example:
select v1.a, v1.b, v2.e, v2.f from
(select t1.a, t2.b from t1 inner join t2 on t1.c=t2.c) v1
inner join
(select t3.e, t4.f from t3 inner join t4 on t3.c=t4.c) v2
where v1.a = 'abcd' and v2.f='xyz'

【在 h****r 的大作中提到】

: can I use only one SQl sentence to select an item from
: multiple table?
: like,
: select item1 from /* here should be another SQL sentence to
: get
: all tablename I want to search item1 */
: where item1 like 'something';
: or at lease can be:
: select item1 from Tab1, Tab2 where item1 like 'something".
: Thanks a lot for help.