Mysql Query to return 2 columns as 1
View Single Post
07-20-2009, 12:40 PM
Join Date: May 2009
What you have written will simply return rows in the format:
Using my example say the column names on either table are different i.e.
I want a way of returning the data like this:
as opposed to this:
Both ID columns are declared the same eg CHAR(2).
I can get what i want using a UNION but cant find a join to do it. I really dont think your basic join example will provide what i'm looking for needs further honed.
View Public Profile
Send a private message to captainmerton
Find More Posts by captainmerton