Try this SELECT * FROM applications LEFT JOIN rejected ON application.appid = rejected.appid WHERE rejected.appid Is Null ORDER BY application.appid DESC;
>>> Wade <[EMAIL PROTECTED]> 4/23/05 3:12:37 PM >>> 04232005 1707 GMT-6 I need to do something like this: $sql = "SELECT * FROM application WHERE appid != rejected.appid ORDER BY appid DESC"; I want to select all from application where the appid is not located in the table rejected. Im having trouble getting this to work. Can somebody help me here? The rejected table has appid's that are rejected. If its in that list then we dont want to call it. Wade
