[thelist] Need a SQL pro

[Phil Turmel]

Chris:

My quick and dirty for this case looks like:

SELECT Table1.* FROM Table1 LEFT JOIN Table2
   ON Table1.auctionID=Table2.auctionID
   WHERE Table2.auctionID IS NULL
   ORDER BY ........;

Phil

Chris Ditty wrote:
> Hi All.  Hopefully a SQL pro here can help me out here.  I have 2
> tables and I want to pull information from one table (table 1) where
> the auctionID in not in the other table (table 2).
> 
> I konw a little bit about table linking, but not enough to do this.
> 
> Table 1
> auctionID
> auctionTitle
> auctionEnd
> etc
> etc
> etc
> 
> Table 2
> auctionID
> auctionShipped
> etc
> etc
> 
> Thanks
> Chris