>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.

Thanks!