Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save othonet/ee1770daa7cc502a39e3ebe5531d7c5a to your computer and use it in GitHub Desktop.
Save othonet/ee1770daa7cc502a39e3ebe5531d7c5a to your computer and use it in GitHub Desktop.
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