joined:June 30, 2008
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?