|
|
Posted by dave on 03/23/07 18:58
Hi,
very new to SQL queries, and strugling with join concept
I had to do a join based on a single field:
select
*
from
tableA, tableB
where
tableA.value = tableB.value(+)
;
this works fine
but how can i do the same thing while comparing multiple columns ... i
was thinking something like this: (obviously doesn't work)
select
*
from
tableA, tableB
where
[tableA.value1, tableA.value2] = [tableB.value1,
tableB.value2](+)
;
Is there some sort of "tuple" comparison I can do?
Thank you.
Navigation:
[Reply to this message]
|