Topic-icon How do I write a query to join two tables

More
07 Mar 2019 02:19 #6758

Hello,
To write a query, you must have knowledge of MySql. The query would be like the following: select a.name, b.value from table1 as a join table2 as b on a.catid=b.id


Thanks
Daniel

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

  • Kelechi Kalu
  • Kelechi Kalu's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
07 Mar 2019 01:28 #6756

Hello,
I would like to create a Table Chart Type containing values from two different tables within an existing Database in my Joomla website. How can I write a query to join two tables?
See the attached screenshot showing two tables that I need to extract information to populate my Table Chart Type.
Kindly provide me a sample query.

Attachments:

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

Cron Job Starts