I am getting closer to fully understanding this. Here is my Query now.
SELECT companytable.companyName, companyindextable.optionsID1, companyindextable.optionsID2, companyindextable.optionsID3, companyindextable.optionsID4
FROM companytable LEFT JOIN companyindextable ON companytable.companyID=companyindextable.companyID
The options descriptions is optionsTitle.
I am sending 3 pics with this. I am going to still work on this later tonight and maybe figure it out. I will let you know.
The original query has all companies that will show what their options are. I believe this would be the basic query for this.
I added the optionsTitle with the select and you will see the results. I believe I need to add another left join, but the optionsTitle is not an interger, but text. I believe you have to have the same type. Would I use a left join with the companyname?