In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!
SELECT
contactDetails.*,
categories.catName as MainCat
FROM contactDetails LEFT JOIN Categories
ON contactDetails.categoryid = Categories.catID
If that works, then:SELECT
contactDetails.*,
categories.catName as MainCat
FROM contactDetails LEFT JOIN Categories
ON contactDetails.categoryid = Categories.catID
LEFT join titles on titles.titleID = contactDetails.titles
ORDER BY contactID DESC
Are you sure the field names are correct, especially contactDetails.titles? Sure it's not contactDetails.titleID?Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
From novice to tech pro — start learning today.
SELECT contactDetails.*,
categories.catName AS MainCat,
titles.title
FROM (contactDetails
LEFT JOIN Categories ON contactDetails.categoryid = Categories.catID)
LEFT JOIN titles on titles.titleid = contactDetails.titles
WHERE Activated = (param 1)
ORDER BY contactID DESC