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
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
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
> 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
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?
> >
>
5 matches
Mail list logo