Can't get two inner joins to work correctly MSSQL

Wappler General
1

I have one table workOrderStatusQry and it has 2 foreign keys to get values. I need the value of the workCenterFK, and I also need the value of WorkOrderStatusFK. If I do a inner join on either I can get the data I need but I need the data from both. Maybe I am doing something wrong?

Capture05122020
Capture051220201041×616 67.8 KB

Capture05122020_2
Capture05122020_2823×301 51.1 KB

2

Inner joins require data to be on both sides of the join, and all joins are cumulative meaning the first join is performed and the next join is performed against the derived table of the first join. It can get confusing.

A left join however, will give you all the results from the first table, and any matches for the second…multiple joins are also cumulative.

I’m guessing you are looking for left joins.

3

thanks I’ll spin that and see what happnes.