Welcome to WebmasterWorld Guest from

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.

Featured Threads

Hot Threads This Week

Hot Threads This Month