you could use the following SQL for Brokerage:
SELECT * FROM jobs WHERE departments LIKE 'Brokerage%'
and this for Carrier:
SELECT * FROM jobs WHERE departments LIKE 'Carrier%'
Hi Jason, thanks so much!! you're right, that should do the trick, the thing is, my query is a little bit complex, for example, the one that should call the brokerage ones is:
SELECT CompanyInfo.CompanyInfo_Logo, CompanyInfo.CompanyInfo_COName, Jobs.Job_Date, Jobs.Job_Position, Jobs.Job_Salary, Jobs.Job_Department, Jobs.Job_Division, Jobs.Job_City, Jobs.Job_State, Jobs.Job_Contact, Jobs.Job_Email, Jobs.Job_Summary
FROM (Jobs
LEFT JOIN CompanyInfo ON CompanyInfo.ID_User=Jobs.ID_User)
ORDER BY Jobs.Job_Date DESC
So now not sure where t place what you explained.
Thanks Jason!
A.-