/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 vote105 views1 answer
How to show index type in postgresql
SQL
1 vote91 views1 answer
Mysql history command
SQL
-1 vote102 views1 answer
Add 10 to all numbers in a column sql
SQL
22 votes96 views3 answers
How to join three tables in sql using joins
SQL
0 vote92 views1 answer
How to count with except in psql
SQL
22 votes104 views3 answers
Year format in date mysql
SQL
5 votes102 views1 answer
Oracle get foreign keys on table
SQL
1 vote98 views1 answer
Give a column name to values generated from case statement in sql
SQL
3 votes92 views2 answers
How to load files in mysql
SQL
2 votes100 views1 answer
Create mysql user on all hosts
SQL