Hi there, thanks for a great solution and support, my question is now (excuse my ignorant).

I need to pull data from two different tables and filter by user id and make FULL JOIN, I have read you post regarding similar thing but after try didnt work for me.

This is the query I hope to use:

SELECT jos_tipster_pro.Deporte, jos_tipster_pro.Fecha, jos_tipster_pro.Rival1, jos_tipster_pro.Rival2, jos_tipster_pro.Cuota
FROM jos_tipster_pro
FULL JOIN jos_tipster_deltio
ON jos_tipster_pro.Tipster=jos_tipster_deltio.tipster_id
ORDER BY jos_tipster_pro.Tipster
WHERE Tipster=1

(I want to show only data from specific user or Tipster)

I cant make it work in Ari Data Tables, please help.
Thanks
Tato

Hello,

Could you specify how "jos_tipster_pro" or "jos_tipster_deltio" table is related to users?

PS: It is possible to use {$UserId} predefined variable in WHERE clause. For example it will look like:

...
WHERE user_id = {$UserId}
...

{$UserId} will be replaced with ID of logged user.

Regards,
ARI Soft

Thanks for fast reply!

The thing is both tables have user id field but named differently one is called "Tipster" and the other is "tipster_id" both are same user but I need to filter the data by this so only show data from the tipster I want and collect this fields

In other words I need to put toghether this two querys but I dont know how to in order to show in a table one per line and ordered by date and filtered by tipster_id and Tipster =1:



I have tried different ways and no success
Many Thanks
Tato

Try the next SQL query:



Regards,
ARI Soft

Amazing!! this works fine now, many thanks great support "On Sunday" as well, kind regards.

Tato