multiple joins between two tables

[deleted_user]

The query I run in EG does not bring any records, if the multiple join (4 columns) is FULL or Right or LEFT Join. Inner joins works fine. How can I accomplish this? Please give your suggestions.

[advoss]

Outer joins get a little tricky if you have Where conditions for columns that come from the [dependent] table. If a table does not contribute attributes for a row in the result set, its resulting columns are null. Therefore, your where clause must accommodate such behavior (see coalesce function).