nelsonm - 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?