Search code examples
mysqlsequelpro

SQL Query Table doesn't exsist


When I am writing a query via Sequel Pro and format it like this a.TBL_ADJUSTMENT I get the following error Table 'a.TBL_ADJUSTMENT' doesn't exist.

How can I write it so that I can label my tables with a letter/number?


Solution

  • Assuming you are trying to select the column my_column from the table my_table, the query you are looking for is select a.my_column from my_table as a

    Aliases