[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