I have this SQL Statement...

SELECT table1.AppNo, table1.p_ID
FROM table1, table2
WHERE table1.p_ID NOT IN (SELECT table2.p_ID FROM table2);

(what i want to do is to select all records that are not contained in table2 [p_ID is unique])

Any suggestions What might goes wrong with this?

Thank you in advance!

Shouldn't need to list table2 in the From clause
SELECT AppNo, p_ID
FROM table1
WHERE p_ID NOT IN (SELECT p_ID FROM table2)

Live the life you love
Love the life you live
~ ~ ~ ~ ~ ~ ~
<b>Simon Martin</b> - <i>DMXzone Manager</i>
<font size=1>[ Dreamweaver MX/MX2004 | ASP | SQL | XHTML/CSS | Web Accessibility ] </font id=size1>