| Welcome to WebmasterWorld Guest from 126.96.36.199 |
register, free tools, login, search, subscribe, help, library, announcements, recent posts, open posts,
|Subscribe to WebmasterWorld|
|A question about selecting data from joined tables.|
| 4:29 am on Dec 8, 2010 (gmt 0)|
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)|
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.
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
© Webmaster World 1996-2014 all rights reserved