Hello SQL Experts,
I have a set of table as shown in this JPG file. Basically, it is our inventory of devices for which it shows our customer code / name, Device status, device connection, interface and interface type.
All devices must have customer code / name and status => I figure the normal query would work (SELECT...FROM...WHERE)
Not all devices will have Connection. When there is a connection, there will always be Interface and Interface type. => Here, I figure there is a LEFT JOIN between DEVICE - CONNECTION
Now, I want to have a query that will be able to pull me the following information
DEVICE_NAME, CUST_CODE, CUST_NAME, STATUS, INT_NAME
Must have: It should be able to list all devices for me, even if there is no CONNECTION for those devices.
Option1: If I need to pull just for a set of CUS_CODE only , where should I put the criteria in the query
Option2: If I need to pull just a set of DEVICE_NAME only
Thank you in advance for you help