SQL add tablename as field

Question

I have seen this done before but i can't remember where i saw it.

What i need to do is have the table name as a field in a query

Say i have a table called users, how would i add the table name 'users' as a column

like

 SELECT username, password, **table** as mytable FROM users

Answer 1

It may look obvious, but did you consider the following?

SELECT username, password, 'users' as mytable FROM users