/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 vote273 views1 answer
Choose only one for each distinct collumn regardless of other columns
SQL
10 votes289 views2 answers
SQL rounding numbers
SQL
0 vote268 views1 answer
How to check the port of mysql installation in mac
SQL
8 votes279 views1 answer
Script to add datafile to tablespace
SQL
0 vote255 views1 answer
Power query datetime to date
SQL
0 vote268 views1 answer
Excute raw query
SQL
0 vote282 views1 answer
Column ' ' in field list is ambiguous
SQL
0 vote274 views1 answer
Power bi union columns
SQL
0 vote283 views1 answer
Sql get number of days between two dates
SQL
4 votes329 views3 answers
Mysql get column names from table
SQL