SQL Query Table doesn't exsist

Question

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?

score 0 · Accepted Answer · answered Nov 21 '16 at 23:03

0

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

answered Nov 21 '16 at 23:03

cck

193
1
14

score 0 · Answer 2 · answered Nov 22 '16 at 01:01

0

Are you referring to a Table Schema:

select a.Table_name from
(select * from information_schema.`TABLES` a) as a

answered Nov 22 '16 at 01:01

Vijunav Vastivch

4,153
1
16
30

You can add where condition if you want to specify your table name. – Vijunav Vastivch Nov 22 '16 at 01:09

SQL Query Table doesn't exsist

2 Answers2