/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

2 votes151 views2 answers
Calculate percentage in sql
SQL
1 vote135 views2 answers
Sql where keyword
SQL
-1 vote131 views3 answers
How to restart mysql in linux
SQL
3 votes129 views3 answers
C# sql select
SQL
5 votes127 views2 answers
Add column postgres with default value
SQL
6 votes131 views2 answers
Mysql get yesterday
SQL
1 vote127 views1 answer
Postgres check for foreign key
SQL
0 vote128 views1 answer
Parsing float to int in mysql
SQL
-1 vote133 views1 answer
Partial search in sql
SQL
0 vote120 views1 answer
Using GROUP BY in MySQL Join Table
SQL