0

Instead of table1 AS t1, can I write table1 t1 ?

So, is JOIN table1 t1 on table2.userid = t1.userid?

Thanks

Identity1
  • 1,139
  • 16
  • 33
Jim
  • 1
  • 3
    Welcome to SO. The answer is yes. But you can try it and after ask the question. maybe dublicate http://stackoverflow.com/questions/2454951/why-would-you-use-as-when-aliasing-a-sql-table – Christos Papoulas Nov 24 '15 at 12:32
  • Possible duplicate of [MySQL AS keyword](http://stackoverflow.com/questions/19567732/mysql-as-keyword) – theINtoy Nov 24 '15 at 13:29

1 Answers1

1

Yes. You could have looked that up yourself.

http://dev.mysql.com/doc/refman/5.7/en/select.html

tbl_name [[AS] alias] [index_hint]

Thorsten Kettner
  • 89,309
  • 7
  • 49
  • 73