Desktop productivity for business analysts and programmers

multiple joins between two tables

Not applicable
Posts: 0

multiple joins between two tables

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.
Frequent Contributor
Posts: 94

Re: multiple joins between two tables

Posted in reply to deleted_user
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).
Ask a Question
Discussion stats
  • 1 reply
  • 2 in conversation