>I have no problem with writing the SQL *sequential style* as follows:
>
>SELECT e.id, e.fname, e.lname, v.vegetable, f.fruit ;
> FROM employee e ;
> LEFT OUTER JOIN vegies v on e.id = v.id ;
> LEFT OUTER JOIN fruits f on e.id = f.id ;
>
>The result has all three employees with a value for vegetable, fruit or both. My problem is trying to write it in ANSI style or trying to duplicate the above result in the Query Builder. I don't get the same result for Employee 3 who has a record in Vegies - the result for him is NULL in the vegetable column.
>
>SELECT Employee.*, Fruits.fruit, Vegies.vegetable;
> FROM employee LEFT OUTER JOIN fruits;
> LEFT OUTER JOIN vegies ;
> ON Fruits.id = Vegies.id ;
> ON Employee.id = Fruits.id
>
>What am I doing wrong?
>TIA

You're using the Query Builder. The Query Builder or View Designer suck. <g>

They do not use the sequential join syntax, only the nested join syntax.