[thelist] [mysql] join
kris burford
kris at midtempo.net
Fri Jan 23 12:39:50 CST 2004
>SELECT table_two.name, some_other_stuff
>FROM table_two
>INNER JOIN table_one
>ON table_one.id_one = table_two.id
>WHERE [x]
>UNION ALL
>SELECT table_two.name, some_other_stuff
>FROM table_two
>INNER JOIN table_one
>ON table_one.id_two = table_two.id
>WHERE [x]
okay, with table.one containing two rows (a, b) that returns*
row1 : a.id_one.name, a.id.some_other_stuff
row2 : b.id_one.name, b.id.some_other_stuff
row3 : a.id_two.name, a.id.some_other_stuff
row4 : b.id_two.name, b.id.some_other_stuff
*or in other terms, with colour and size as the two id references, plus
quantity as the "other stuff":
row1 green 5
row2 orange 10
row3 large 5
row4 small 10
whereas what i was hoping for was
row1 : a.id_one.name, a.id_two.name, a.id.some_other_stuff
row2 : b.id_one.name, b.id_two.name, b.id.some_other_stuff
any ideas??
tia
kris
More information about the thelist
mailing list