e_two.table_two_id
> where which=1 and col1 is not null
> or which=2 and col2 is not null
> order by date, which;
>
>
> From: "Andy Hall" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> > Subject: UNION equivilent required for 3.23.37
>
le.table_one_id = table_one.table_one_id
left join table_two on root_table.table_two_id = table_two.table_two_id
where which=1 and col1 is not null
or which=2 and col2 is not null
order by date, which;
From: "Andy Hall" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Hi,
I have looked for answers on the net but havent managed to apply the
suggestions to my example; I would appreciate any help!
I have the following set up:
root_table (root_table_id, table_one_id, table_two_id, date)
table_one (table_one_id, col1)
table_two (table_two_id, col2)
I want to us
