I think I have a fundamental understanding on how to use the Public schema to help run custom reporting but what I am confused on is in the screenshot. What do the s. and u. before the column names mean in the query?
I think I have a fundamental understanding on how to use the Public schema to help run custom reporting but what I am confused on is in the screenshot. What do the s. and u. before the column names mean in the query?
The s an u are aliases that are defined in the from part of the clause. you can then reference columns in those tables using the alias so the right namespace is used.
For example,
select s.id from users s
s is the alias defined in this case.