/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

0 vote180 views1 answer
Eliminar ultimo carcacter mysql
SQL
1 vote176 views1 answer
SQL query to get all table records count from a database
SQL
0 vote174 views1 answer
How to stop all connections to a psql 12 database?
SQL
0 vote140 views2 answers
Postgresql could not start server mac
SQL
1 vote182 views1 answer
Sql server list locks
SQL
0 vote186 views1 answer
Influxdb clone measurement
SQL
0 vote125 views3 answers
Django.core.exceptions.improperlyconfigured: error loading mysqldb module. mac
SQL
0 vote207 views1 answer
Excel vba import data to sql server
SQL
0 vote212 views1 answer
Postgres list users and roles
SQL
0 vote169 views1 answer
Mysql get 2nd value in comma separated list
SQL