[thelist] DB design question
rudy
r937 at interlog.com
Fri Dec 6 21:09:01 CST 2002
>> Access only supports right,
there must be some misunderstanding
there must be some kind of mistake
(I waited in the rain for hours... and you were late)
um, where was i?
oh yeah
i *never* use right joins (intellectual weakness on my part, i confess)
but i use left joins in access all the time with no problem
in the properties-amenities situation, it would be okay to use inner joins
i mean, the outer joins (left or right) had better not return more rows than
inner
that would indicate what i would call "broken links"
rudy
More information about the thelist
mailing list