I have about 4 attributes of a table called Customer which has a primary key CustomerId then FirstName, lastname, phonenumber
Then it has a relationship with another table called Application with a primary key of ApplicationId then Type, ExpiryDate, CustomerID
CUSTOMER(CustomerID, FirstName, LastName, PhoneNumber)
APPLICATION(ApplicationID, Type, ApplicationNumber, CustomerID*)
They are linked up through the customerID
What I want is to have 1 query that grabs all the customer details and only the ApplicationNumber (Which is linked up with the customerID). But if a customer doesn't have an application then it still shows that customer in the query but with a blank application number.
Thank you! I've been working on this for a while.
Then it has a relationship with another table called Application with a primary key of ApplicationId then Type, ExpiryDate, CustomerID
CUSTOMER(CustomerID, FirstName, LastName, PhoneNumber)
APPLICATION(ApplicationID, Type, ApplicationNumber, CustomerID*)
They are linked up through the customerID
What I want is to have 1 query that grabs all the customer details and only the ApplicationNumber (Which is linked up with the customerID). But if a customer doesn't have an application then it still shows that customer in the query but with a blank application number.
Thank you! I've been working on this for a while.