| Welcome to WebmasterWorld Guest from 220.127.116.11 |
register, free tools, login, search, subscribe, help, library, announcements, recent posts, open posts,
|Pubcon Platinum Sponsor 2014|
|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.
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved