I am working on the Queries that I would like to use.
I have 3 options, Facebook,Twitter and Website (1,2 and 3). I only have 1 company within the database.
I have been working with recordset over and over trying to get it right. This is my CompayOptionALL query. I will make one for each option. I hope that is the correct way.
Problem is, when I run it, I only want one record. The MD Web Design is shown twice. How do I only get that one record?
I have attached the jpg for the test SQL Statement
SELECT companytable.companyName, companyindextable.optionsID1, companyindextable.optionsID2, companyindextable.optionsID3, companyindextable.optionsID4, optionstable.optionsID
FROM companytable, companyindextable, optionstable
WHERE optionstable.optionsID > "1"