SELECT * FROM TABLE1 A
WHERE EXISTS (
SELECT * FROM TABLE2 B,TABLE3 C
WHERE B.DM=C.DM
AND B.ID=A.ID
AND C.dmmc='手机'
)如果已经知道手机的代码:SELECT * FROM TABLE1 A
WHERE EXISTS (
SELECT * FROM TABLE2 B
WHERE B.ID=A.ID
AND B.dm='002'
)
WHERE EXISTS (
SELECT * FROM TABLE2 B,TABLE3 C
WHERE B.DM=C.DM
AND B.ID=A.ID
AND C.dmmc='手机'
)如果已经知道手机的代码:SELECT * FROM TABLE1 A
WHERE EXISTS (
SELECT * FROM TABLE2 B
WHERE B.ID=A.ID
AND B.dm='002'
)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货