Multi-user sync with render_sql on 2 tables

[Mory]

Hi,

I got an sql error when I’m trying to use multi-user sync with a gridConnector using render_sql on 2 tables.

Here my code :

$data->render_sql ( "SELECT * FROM sm_message INNER JOIN sm_ipad ON sm_message.ipad_id = sm_ipad.ipad_id ORDER BY message_date DESC, “message_id”, “message_status,message_tag,message_title,ipad_name,message_date,message_type” );

And the error from the log file :

SELECT * FROM actions_table LEFT OUTER JOIN sm_message INNER JOIN sm_ipad ON sm_message.ipad_id = sm_ipad.ipad_id ON actions_table.DATAID = sm_message INNER JOIN sm_ipad ON sm_message.ipad_id = sm_ipad.ipad_id.message_id WHERE ( actions_table.ID > ‘2’ AND actions_table.USER <> ‘1323084909628’) ORDER BY message_date DESC LIMIT 0,20

!!!Uncaught Exception
Code: 0
Message: MySQL operation failed
Not unique table/alias: ‘sm_ipad’

Any idea about the way to fix it ?

Thanks.

[radyno]

Hi,
try to use render_complex_sql method instead of render_sql.