- Posts: 1
- Thank you received: 0
MySQL query with two tables and join
Is this query possible with Table JX ?
SELECT * FROM xyz p
LEFT JOIN xyz s
ON p.xyz = s.xyz
WHERE xyz like '%$xyz%'
If yes , i would buy it
thanks for info
Please Log in or Create an account to join the conversation.
Hi,
It is possible to select data from more than one table by using a database view. You can learn more on this topic on the following links:
toolsjx.com/support/3-suggestions/646-pu...tables-in-a-database
toolsjx.com/support/2-installation/1259-...ql-view-in-table-jxq
dev.mysql.com/doc/refman/5.0/en/create-view.html
Regards,
Tomaž
Please Log in or Create an account to join the conversation.