- Posts: 1
- Thank you received: 0
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?
Please Log in or Create an account to join the conversation.
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.