/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 vote266 views1 answer
How to connect to xampp sql server on windows cmd
SQL
3 votes146 views1 answer
V$session not found in oracle
SQL
1 vote188 views3 answers
String to int mysql
SQL
0 vote246 views1 answer
Alternative for LIMIT sql
SQL
0 vote245 views1 answer
Mysql error 1114 (hy000) the table is full
SQL
1 vote213 views1 answer
SQl Server Versionen Releases und Build-Nummern
SQL
0 vote271 views1 answer
Generate sql from specific migration ef core
SQL
0 vote229 views1 answer
SQL Query to delete all the tables in a database
SQL
0 vote227 views1 answer
Count number of entires by months sql
SQL
2 votes180 views2 answers
Mysql all columns
SQL