/SQL/Sql query use select name inside where clause

Sql query use select name inside where clause

You can not use aliased columns in a WHERE clause. You can try using a derived
table. Perhaps something like this (sorry, not tested):

select tblProgram.POIname from tblProgram
where 
  -- Use this if you only want to filter by the value.
  (select count(*) as alias_name from `fb_promo_codes_used`) < 2

Similar codes

2 votes324 views3 answers
Write sql query to find the second highest salary of employee
SQL
16 votes416 views2 answers
Sql vs nosql
SQL
0 vote376 views1 answer
Pgadmin save data greyed out
SQL
1 vote313 views1 answer
Oracle lowercase
SQL
1 vote374 views1 answer
Create new table from old table
SQL
3 votes356 views3 answers
Restart mysql mac
SQL
1 vote291 views1 answer
Mysql see column types
SQL
9 votes319 views4 answers
Add primary key to existing table sql
SQL
0 vote352 views1 answer
Uncheck constraints and delete from table
SQL
2 votes341 views1 answer
ADD COLOUNS CREATED AND UPDATED AT IN MYSQL
SQL