/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 vote283 views1 answer
Mysql root localhost run
SQL
4 votes286 views3 answers
Is not null sql
SQL
0 vote281 views1 answer
How to combine rows in sql server procedure
SQL
6 votes297 views2 answers
Difference between join vs union
SQL
2 votes284 views1 answer
How to find constraints on a table in oracle
SQL
0 vote283 views1 answer
Datetime postgres typeorm
SQL
1 vote261 views2 answers
Pl sql case
SQL
1 vote285 views1 answer
Md5 encryption for existing records
SQL
25 votes312 views4 answers
Import mysql dump command line
SQL
0 vote299 views1 answer
Rows, INSERT INTO, Returning
SQL