/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 vote255 views1 answer
Savepoint mysql script
SQL
0 vote223 views1 answer
Redirection 301 htaccess nom de domaine
SQL
0 vote232 views1 answer
Split string by comma in sql server
SQL
1 vote242 views1 answer
Postgresql pass array in function
SQL
0 vote248 views1 answer
Create table as select sql server error
SQL
0 vote240 views1 answer
If column value is null then in mysql
SQL
0 vote224 views2 answers
Mysql slave status
SQL
0 vote235 views1 answer
Grepper sql workbench download
SQL
0 vote254 views1 answer
C# get sql min date
SQL
2 votes236 views1 answer
Mysql query unique column
SQL