lar selects?
select * from aa inner join bb on (aa.i=bb.i);
aa.i aa.j bb.i
--
1 2 1
5 6 5
select * from aa inner join bb using (i);
aa.i aa.j
1 2
5 6
Thanks,
Rob.
On Apr 12, 2004, at 5:00 AM, D. R
I'm a novice SQL user, and I'm confused by an apparently arbitrary
limitation on multiple inner joins. I'm able to use the "using" clause
for the first join but not for the second. I assume that I'm doing
something silly out of ignorance. Any explanation for this behavior
will be greatly
2 matches
Mail list logo