https://antibiotiqueaugmentin.com/surdosage-augmentin-bebe/
× Welcome to the ToolsJX forum!


MySQL query with two tables and join

  • spacemallow
  • spacemallow's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
11 years 11 months ago #1723

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

Last edit: 11 years 11 months ago by spacemallow.

Please Log in or Create an account to join the conversation.

More
11 years 11 months ago #1724

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.

Moderators: tomaz
Time to create page: 0.146 seconds

Contact Us

Contact us on Discord

Contact us on Facebook