https://communities.sas.com/t5/SAS-Enterprise-Guide/multiple-joins-between-two-tables/m-p/7137#M2265 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. Tue, 26 Feb 2008 20:09:47 GMT deleted_user 2008-02-26T20:09:47Z https://communities.sas.com/t5/SAS-Enterprise-Guide/multiple-joins-between-two-tables/m-p/7137#M2265 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. Tue, 26 Feb 2008 20:09:47 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/multiple-joins-between-two-tables/m-p/7137#M2265 deleted_user 2008-02-26T20:09:47Z https://communities.sas.com/t5/SAS-Enterprise-Guide/multiple-joins-between-two-tables/m-p/7138#M2266 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). Wed, 27 Feb 2008 14:21:48 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/multiple-joins-between-two-tables/m-p/7138#M2266 advoss 2008-02-27T14:21:48Z