Multiple Table Query

2004-10-15 Thread Nick Baker
Am I going about selecting from two tables in the right manner? 1. Select all email addresses (variable Email) from Table "condensed". ID2 is the index 2. Then the entire record for the  email addresses ((variable Email2) table "mailist"  that match the email addresses in Table "condensed" Cod

Re: Multiple Table Query

2004-10-15 Thread Barney Boisvert
SELECT maillist.* FROM condensed    INNER JOIN maillist ON condensed.email = maillist.email2 That says "select everything from the maillist table, where the maillist.email2 field is equal to the condensed.email field".  You don't need to select the condensed.email field, because it's guarentee

Re: Multiple Table Query

2004-10-15 Thread Anders Green
At 05:54 PM 10/15/2004, Nick Baker wrote: >Am I going about selecting from two tables in the right manner? > > >1. Select all email addresses (variable Email) from Table "condensed". ID2 >is the index > >2. Then the entire record for the  email addresses ((variable Email2) table >"mailist"  that ma

RE: Multiple Table Query

2004-10-15 Thread Dave Watts
> Am I going about selecting from two tables in the right manner? > > 1. Select all email addresses (variable Email) from Table > "condensed". ID2 is the index > > 2. Then the entire record for the  email addresses ((variable > Email2) table "mailist"  that match the email addresses in > Table

Re: Multiple Table Query

2004-10-15 Thread Greg Luce
Dave, don't you subscribe to the "INNER JOIN" syntax? SELECT    email FROM   condensed INNER JOIN maillist ON condensed.ID2 = maillist.ID2 Greg On Fri, 15 Oct 2004 18:12:07 -0400, Dave Watts <[EMAIL PROTECTED]> wrote: > > Am I going about selecting from two tables in the right manner? > > >