Query 5 Tables

[Speegs]

Hello,
I have five tables, each with a unique identifier 'email'
How can I query the five tables to only show results where all the email values are =
???
Speegs

[Tom Muck]

"Speegs" <webforumsuser@macromedia.com> wrote in message
news:d1f8cg$ior$1@forums.macromedia.com...

> Hello,
> I have five tables, each with a unique identifier 'email'
> How can I query the five tables to only show results where all the email

values are =

> ???
> Speegs

What database? Equal to what? In SQL Server, I would do somethign like this:

SELECT email FROM table1
UNION
SELECT email FROM table2
UNION
SELECT email FROM table3

etc

Save as a view, then query the view:

SELECT email FROM myView WHERE email = '???'


--
-------------------------------------------
Tom Muck
co-author Dreamweaver MX 2004: The Complete Reference
[url]http://www.tom-muck.com/[/url]

Extending Knowledge, Daily
[url]http://www.CommunityMX.com/[/url]