56,687
社区成员
发帖
与我相关
我的任务
分享
select T1.*,T2.*
from
(
select *
from no1
where c='张三'
)T1,
(
select *
from no2
where b='李四'
)T2
where T1.fid=T2.id
select
a.*,'
b.*
from NO1 a,NO2 b
where a.fid=b.id
and a.C='张三' and b.b='李四'
SELECT TMP1.*,TMP2.*
FROM
(SELECT * FROM NO1 WHERE C='张三') TMP1 INNER JOIN (SELECT * FROM NO2 WHERE B='李四') TMP2
ON TMP1.FID=TMP2.ID;
select a.*,b.*
from no1 a inner join no2 b on a.fid=b.id
where a.c='张三' and b.b='李四'