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.
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).
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.