DB Read - How to join tables?

Question

Hi,I try to read data from one table via the condition of a second table - but I cannot manage to put the mysql query into that structure of DB Read Event. Which is in such a case main table, which the related second? Whatever I tried, I got errors such as "there is no model.column in tableX".​How would a query like this one be set into work in CF?​SELECT tableA.created, tableA.title FROM tableA LEFT JOIN tableB ON tableA.id = tableB.itemid WHERE tableB.catid = 11 ORDER BY tableA.created DESC LIMIT 1;​I am somehow stuck and so thankful for any advice.Herbert

Max_admin · Accepted Answer

Hello HerKle,​You better use v7 which can be installed with v5 on the same website, the relations are easier to setup and there is a SQL data action where you can just write your own SQL code

Forums

DB Read - How to join tables?