oracle查詢一個(gè)表的所有字段 查詢一個(gè)表中所有id字段在另一個(gè)表中對(duì)應(yīng)值的SQL語(yǔ)句怎么寫?
查詢一個(gè)表中所有id字段在另一個(gè)表中對(duì)應(yīng)值的SQL語(yǔ)句怎么寫?子查詢即可 SELECT (SELECT name FROM TA WHERE id = TB.id1) AS id1, (SELECT
查詢一個(gè)表中所有id字段在另一個(gè)表中對(duì)應(yīng)值的SQL語(yǔ)句怎么寫?
子查詢即可 SELECT (SELECT name FROM TA WHERE id = TB.id1) AS id1, (SELECT name FROM TA WHERE id = TB.id2) AS id2 FROM TB