[thelist] Need a SQL pro

[Ken Schaefer]

How many times has it been pointed out that you should tell us what
DBMS you are using?

Something like (this is not tested, and I've typed it directly into
gmail's web interface, so there are probably typos):

SELECT
   a.AuctionID
FROM
   table1 AS a
WHERE NOT EXISTS
   (
      SELECT
         NULL
      FROM
         table2 AS b
      WHERE
         a.auctionID = b.auctionID
   )

should get you started.

HTH

Cheers
Ken

On Wed, 25 Aug 2004 18:47:31 -0500, Chris Ditty <cditty at gmail.com> 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