I need help with rewriting a sql query. Nested queries that work in MS databases apparently do not work in MySQL databases. Here is what I need in MS query pseudo code:
SELECT table1.myfield1, table2.myfield2 FROM table1, table2 WHERE table1.key=table2.key AND myfield1="something" AND myfield2 NOT IN (SELECT myfield2 FROM table3 WHERE table3.myfield3="whatever") For example, if I wanted to get all Forum Posts (Table1) for TopicA that do NOT have replies (Table3) by User1. I have been going crazy trying joins - lefts, rights, inners, outers... Any help would be greatly appreciated!! __________________________________ Do you Yahoo!? Yahoo! Search - Find what you’re looking for faster http://search.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
