Basic SQL, SELECT
statement -6
nSometimes SQL
statements can get verbose. As a shorthand,
you can specify aliases for the table names.
SELECT MG.*
FROM model_group MG, user U
WHERE U.username = ‘jssmith’
AND U.user_id = MG.user_id
Result:
MODEL_GROUP_ID
USER_ID MODEL_GROUP_NAME
11
122 Jeff’s Ensemble