SQL Select queries

Posted by sds on Stack Overflow See other posts from Stack Overflow or by sds
Published on 2010-04-18T00:48:51Z Indexed on 2010/04/18 0:53 UTC
Read the original article Hit count: 255

SELECT * FROM TABLE_A A WHERE A.ID IN (SELECT B.ID FROM TABLE_B B)

SELECT * FROM TABLE_A A, TABLE_B B WHERE A.ID = B.ID

© Stack Overflow or respective owner