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?
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