Can't get two inner joins to work correctly MSSQL

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?

Community Page
Last updated: