Help with SSP Class multiple table query

aura_110

Hello,
I am very new to datatables and I need help with a query to work with ssp.class.php

What would be the equivalent of

“SELECT tableA.*, tableB.*, tableC.offer_id, tableC.main_id, tableC.stat, tableD.data FROM tableA, tableB, tableC, tableD WHERE tableA.main_id = tableD.main_id AND tableC.main_id=tableA.main_id AND tableA.rep_id=tableB.rep_id AND tableC.offer_id IN (SELECT MAX(offer_id) FROM tableC GROUP BY main_id) GROUP BY tableA.main_id ORDER BY tableA.main_id DESC”;

?

It’s just multiple table SELECT query with multiple WHERE clause, but I am unable to make it work with ssp class.

Highly appreciate your help

JP

colin

I would suggest creating a view in the database with that query, and then SSP accesses that view. If that's not possible, let us know, and we'll look more into it.

Colin