>SELECT x.*,y.* FROM x LEFT OUTER JOIN y ON x.key = y.key
>
>Try that :-)
>
That worked, the interesting thing is that .NULL. is returned in child table fields. So I will have to work with that. The other thing I saw was that it was not very fast in relation to a regular not outer join SQL.
The bottom line is you helped and I appreciate it, thanks John..
Bret Hobbs
"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope