/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 vote160 views1 answer
Add column not null with default value postgres
SQL
0 vote154 views1 answer
How to set all the min and sec data to zero in sql server
SQL
4 votes159 views1 answer
Wilayah indonesia sql
SQL
0 vote179 views1 answer
Reset postgres table index to next max value
SQL
0 vote157 views1 answer
Mysql illegal mix of collations for operation 'concat'
SQL
0 vote153 views1 answer
Having trouble running COUNT in my INSERT INTO statement
SQL
0 vote196 views1 answer
Sql select without column name
SQL
0 vote154 views1 answer
Sql roll up rows into columns
SQL
0 vote195 views1 answer
Postgres docs /copy metacomand
SQL
0 vote136 views0 answer
SQL