>Hi James,
>
>I usually put the word OUTER like in LEFT OUTER JOIN. I not sure it is mandatory but try it. Otherwhise, your select looks good to me.
Thanks Diane:
I've tried every join combination using the View Wizard and Programacticly.
Nothing seems to work and this should be at the SQL 101 level.
Any other ideas would be appreciated,
Thanks Again,
Curtis (I work for Jim)
- jim durkin
"The universe is a big place, perhaps the biggest." Kurt Vonnegut