A question about selecting data from joined tables.

[nelsonm]

Hi all,

You join two tables, such as a United States and a Canadian postal code table, where each has a PostalCode field.

I know that you can "SELECT us.PostalCode, ca.PostalCode from us JOIN ca ON whatever".

The question is...

Can i "SELECT PostalCode from us JOIN ca ON whatever"? In other words, can i have the query dump all the postal codes from both tables into the single results field array?

[coopster]

Sounds like a job for UNION. I don't know which database you are using, but here is the MySQL man page for UNION Syntax, should get you started in the right direction.
[dev.mysql.com...]