/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 vote352 views1 answer
Postgres multiple left join causing duplicates jsonb_agg
SQL
0 vote341 views2 answers
Oracle create tablespace autoextend
SQL
0 vote320 views1 answer
Postgresql regular expression special characters
SQL
4 votes294 views2 answers
Select todays data postgres query
SQL
0 vote330 views1 answer
Two inner joins sql
SQL
1 vote327 views1 answer
Mysql current time
SQL
0 vote324 views3 answers
Insert query in ci
SQL
1 vote314 views1 answer
Sql to mongodb query converter
SQL
2 votes323 views2 answers
Change varchar length mysql
SQL
0 vote324 views1 answer
Mysql set column equal to another automatic
SQL