"adrian Greeman" <[EMAIL PROTECTED]> wrote:
> There is a particular form of SQL query you can use I believe when you
> are adding data to a table and want to include an ID number from another
> lookup table but you only know the name reference and not the ID
>
> eg it might be an "author" table wi
017
-Original Message-
From: adrian Greeman [mailto:[EMAIL PROTECTED]
Sent: Friday, May 21, 2004 1:12 AM
To: [EMAIL PROTECTED]
Subject: simple question on WHERE SELECT query
There is a particular form of SQL query you can use I believe when you
are adding data to a table and want to include an
There is a particular form of SQL query you can use I believe when you
are adding data to a table and want to include an ID number from another
lookup table but you only know the name reference and not the ID
eg it might be an "author" table with an author_id and author_name and
you want to enter
