In vfp and T-SQL Left, Right and Full are all outer joins and the typing of "outer" is optional. Weekend level definition of outer: has nulls if no match available Pretty sure that is in synch with SQL standards, but perhaps a specific implementation has other rules.