left join in entities

(0) Share

Report

Posted on by ..

1,273

Hi,

I have a table with 29 records, this table has a filed called PostalAddress(RecId) which has a relation with logisticsPostalAddress.Location
As you can see sometimes the field is filled and sometimes not.
Total # of records is 29 (only 4 records has postal address filled)

I created an entity for this table -- with outerJoin LogisticsPostalAddress and then inner join with Logisitics Location

It started returning 4 records to me.
However, when I made logisticsPostalAddress outer join with logisticsPostalAddress, it started return 29 records.

my question is, we all know that outer join in entity is a left join, so why when i made inner join with logsiticsLocation it started returning only 4 records and not 29? I'm assuming the outer join with logistics postal address returns anything in the main table the doesn't have an address. And since logsiticsLocation relation is with LogisticsPostalAddres, why did the inner join return 4 records instead of 29?

All responses (2)

Answers (0)

Suggested answer

Waed Ayyad 6,619 Super User 2024 Season 2 on at

Like (0)

Report

left join in entities

Hi ,

The inner join between logisticsLocation and LogisticsPostalAddress is return only the records that have that location(RecID) on logisticsLocation table, so it is expected to return only the 4 records.
Suggested answer

Martin Dráb 230,488 Most Valuable Professional on at

Like (0)

Report

left join in entities

Inner join returns records for which the relation has records on both sides. As you showed on your screenshot, there are only four records in PostalAddress that have a relation to LogisticsPostalAddress and these are the records you get by inner-joining the tables.