/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 vote270 views1 answer
Download sql file of countries names
SQL
4 votes235 views3 answers
Is not null sql
SQL
5 votes243 views1 answer
Mysql where one year ago
SQL
0 vote230 views1 answer
ORACLE PARSE STRING
SQL
1 vote217 views1 answer
Update and replace mysql
SQL
0 vote227 views1 answer
Mysql make date from 2 column
SQL
0 vote177 views1 answer
Denied
SQL
1 vote231 views1 answer
Postgresql create table with timestamp
SQL
0 vote221 views1 answer
Rabbitmq ui not working
SQL
1 vote239 views1 answer
Epoch time converter in snowflake
SQL