/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 vote347 views3 answers
Get count of null in column sql
SQL
0 vote373 views1 answer
Mariadb date equals to current_date plus days
SQL
10 votes362 views6 answers
Mysql delete duplicates
SQL
0 vote357 views1 answer
Alter table add foreign key mariadb example
SQL
4 votes350 views2 answers
Mysql select where starts with
SQL
1 vote343 views1 answer
Real world example of nosql
SQL
0 vote363 views1 answer
Get date ISO in psql
SQL
2 votes360 views1 answer
When matched in sql server
SQL
5 votes380 views2 answers
Sql server port number
SQL
0 vote392 views1 answer
Select distinct after join
SQL