Wednesday 15 April 2015

sql - What does meaning a part of query? -



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