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
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
