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


sql query - join supported?

  • chanpeter88
  • chanpeter88's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
12 years 8 months ago #1199

i want to display the alphauserpoints history (jos_alpha_userpoints_details) for current login user only. the history table does not contain userid directly.

1. history table
jos_alpha_userpoints_details
id, referreid, points,

2. map alphauserpoints userid to joomla userid
jos_alpha_userpoints
id, userid

pls advise if the sql query contains join between these 2 tables, will this be supported?

Last edit: 12 years 8 months ago by chanpeter88.

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

More
12 years 8 months ago #1203

Hi,

You can create a database view, and use it to display with our component.

More about views:

dev.mysql.com/doc/refman/5.0/en/create-view.html

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

Moderators: tomaz
Time to create page: 0.152 seconds

Contact Us

Contact us on Discord

Contact us on Facebook