/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 vote362 views1 answer
Mysql date without time
SQL
-1 vote355 views1 answer
Can pandas fetch data from sql
SQL
0 vote358 views1 answer
Automated psql csv export script on windows
SQL
6 votes429 views2 answers
Oracle compile trigger
SQL
8 votes335 views1 answer
Oracle add month
SQL
0 vote350 views1 answer
Install sql server in ubuntu 20.04
SQL
0 vote363 views1 answer
How to add boolean column in postgresql
SQL
8 votes363 views2 answers
Oracle undo usage
SQL
0 vote329 views1 answer
If null don't update
SQL
0 vote350 views1 answer
Mysql c commands
SQL