Welcome to WebmasterWorld Guest from 107.20.20.39

Forum Moderators: open

Message Too Old, No Replies

A question about selecting data from joined tables.

   
4:29 am on Dec 8, 2010 (gmt 0)

5+ Year Member



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?
2:55 pm on Dec 8, 2010 (gmt 0)

WebmasterWorld Administrator coopster is a WebmasterWorld Top Contributor of All Time 10+ Year Member



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...]