sql - What does meaning a part of query? -
i follow query teammate. cam understand part of query. think meaning output name field db_user , direct_groups table if name field equal dba direct_groups table. right??
select a.name db_user, table(direct_groups) t(roles) roles.name = 'dba'
that doesn't valid sql. nil has alias "a" hence can't select "a.name". looks code attempting select user "names" users have role = "dba".
sql
No comments:
Post a Comment