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