2 mysql tables 1 grid

Suite and Optimus Suite 5
#1

Hello all,

I’ve read through some other posts regarding this question. Has anyone else successfully implemented two mysql tables into one grid?

I have two tables, customer_shipping and customer_billing. They use many of the same columns, but different information. I’ve setup the table to handle all the information received by one table without issue. However I can’t get it to work with 2.

Anyone have any suggestions?

Thanks

#2

Hi,
to join two tables in one grid you have to use render_sql connector call:
docs.dhtmlx.com/doku.php?id=dhtm … operations
and to pass sql-request with JOIN construction.

If tables have fields with the same names you may use aliases:
docs.dhtmlx.com/doku.php?id=dhtm … ta#aliases