/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 vote326 views1 answer
Sql server alter table add column tinyint
SQL
2 votes293 views2 answers
Join update query in sql
SQL
0 vote340 views1 answer
Pgadmin save data greyed out
SQL
0 vote311 views1 answer
Sql server select value large text
SQL
5 votes303 views1 answer
Alter table add comment oracle
SQL
0 vote292 views1 answer
Replace null value within column mysql
SQL
0 vote318 views1 answer
Sql where part of string match
SQL
0 vote298 views1 answer
Sql grant select only
SQL
0 vote284 views0 answer
SQL
0 vote325 views1 answer
How to update date value in sql
SQL