Skip to content

Instantly share code, notes, and snippets.

  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
Star You must be signed in to star a gist
Embed
What would you like to do?
Applying INNER JOIN in Select Dynamic, referencing logged current user (Live) - SEBLOD Dynamic Select
SELECT #__table1.column_datas
FROM #__table1
INNER JOIN #__users /* Table Users Joomla. */
ON #__table1.column_username = #__users.username /* The call #__ users.username takes all users registered on Joomla. */
WHERE #__users.username = "$user->name" /* Condition that checks and retrieves the name of the current logged in user. */
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment