3 messages in com.mysql.lists.win32I need help with a Select Query
FromSent OnAttachments
Wade23 Apr 2005 15:12 
Petr Vileta23 Apr 2005 17:06 
jbon...@sola.com.au25 Apr 2005 16:01 
Subject:I need help with a Select Query
From:Wade (wa@wadesmart.com)
Date:04/23/2005 03:12:15 PM
List:com.mysql.lists.win32

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