I am having some trouble getting my data out of my MSSQL database. I have three tables (Contact, ContactInfo, and ContactType). When I execute the query below I only get values back it has a reference in ContactInfo. Is there a way to get all the data out of Contact even if there is no reference in ContactInfo. I have attached a screen capture of my database diagram to help.
SELECT Contact.*, ContactInfo.*, ContactType.*
FROM Contact INNER JOIN
ContactInfo ON Contact.ContactID = ContactInfo.ContactID INNER JOIN
ContactType ON ContactInfo.ContactTypeId = ContactType.ContactTypeId
Question
heffer86
I am having some trouble getting my data out of my MSSQL database. I have three tables (Contact, ContactInfo, and ContactType). When I execute the query below I only get values back it has a reference in ContactInfo. Is there a way to get all the data out of Contact even if there is no reference in ContactInfo. I have attached a screen capture of my database diagram to help.
Link to comment
Share on other sites
2 answers to this question
Recommended Posts