close
找了半天,原來寫法就這麼簡單:
SELECT A.filename,
C.filename,
A.filename,
B.filename
FROM talbe1 A, tabl2 B, table3 C
WHERE A.key1 = B.key1
AND A.key2 = B.key2
AND A.key1 = C.key1
後面再加其他需要篩選的條件,搞定!
全站熱搜
留言列表