>>It's only when your dealing with LEFT OUTER JOIN or RIGHT OUTER JOIN that the location of the table/database name in the syntax has an effect. HTH.
>
>Thanks Roxanne, that is exactly what I thought. I was asked to investigate if SQL code using inner joins 'sometimes' produces wrong results. I can't duplicate what was reported as a error, but I am still searching. VF6-Ent Dev by Paddock et al has a great SQL chapter so I am going to pull that off the shelf and reread it.

There's anothe great general ANSI SQL book I consider a must have... problem is my last employer bought my copy & I long since left it behind. Let me get some coffee in me & I'll remember the name & post it.

(Hey Mike Levy, what's the name of that darn SQL book? I know you got a copy, you turned me onto it)