/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 vote115 views1 answer
Spring Flyway Teams Edition or MySQL upgrade required: MySQL 5.5 is no longer supported by Flyway Community Edition, but still supported by Flyway Teams Edition.
SQL
3 votes144 views3 answers
Order by postgres
SQL
0 vote159 views1 answer
Uncaught PDOException: SQLSTATE[HY000] [1698]
SQL
4 votes131 views3 answers
Drop Table Oracle
SQL
3 votes111 views1 answer
Select without null values sql
SQL
3 votes134 views2 answers
Mysql import gz
SQL
0 vote129 views1 answer
Create database like
SQL
0 vote120 views1 answer
How to check the port of mysql installation in mac
SQL
4 votes172 views1 answer
Oracle change nls_date_format permanently
SQL
1 vote121 views1 answer
Simple project for database
SQL