/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

1 vote200 views1 answer
Install postgresql on raspberry pi
SQL
0 vote204 views1 answer
Open postgresql.conf in centos
SQL
0 vote178 views1 answer
Rabbitmq service not starting
SQL
1 vote183 views3 answers
Mysql Server Start
SQL
1 vote184 views2 answers
Sql where keyword
SQL
5 votes211 views4 answers
Traduction
SQL
16 votes209 views1 answer
Mysql reset auto increment value
SQL
0 vote203 views1 answer
Convert excel into sqllite db using python
SQL
0 vote188 views1 answer
Postgresql create table with boolean column
SQL
3 votes196 views3 answers
Into in sql
SQL