/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

1 vote311 views1 answer
Sql only five first row
SQL
0 vote330 views1 answer
Get sum sqlite android
SQL
0 vote288 views3 answers
Mysql calculate age from date of birth
SQL
7 votes337 views5 answers
Show details of table postgres
SQL
0 vote368 views1 answer
Mariadb create index if not exists
SQL
0 vote332 views1 answer
Mysql to get column name in database
SQL
7 votes326 views1 answer
Safe update mysql
SQL
0 vote296 views1 answer
Postgres create database if not exists
SQL
13 votes349 views5 answers
Alter table query sql server change column
SQL
0 vote331 views1 answer
Mysql grouping functions
SQL