TalkPHP - View Single Post

captainmerton · 07-20-2009, 12:40 PM

What you have written will simply return rows in the format:

data1,data2
data1,data2

Using my example say the column names on either table are different i.e.

Table1
ID1 DATA1
10 blahblah
15 blahblah

Table2
ID2 DATA2
20 blahblah

I want a way of returning the data like this:

ID1
ID1
ID2
ID1

as opposed to this:

ID1,ID2
ID1,ID2

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.

07-20-2009, 12:40 PM	#6 (permalink)
captainmerton The Acquainted Join Date: May 2009 Posts: 178 Thanks: 9	What you have written will simply return rows in the format: data1,data2 data1,data2 Using my example say the column names on either table are different i.e. Table1 ID1 DATA1 10 blahblah 15 blahblah Table2 ID2 DATA2 20 blahblah I want a way of returning the data like this: ID1 ID1 ID2 ID1 as opposed to this: ID1,ID2 ID1,ID2 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.