/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 votes219 views1 answer
Q operator in plsql
SQL
-1 vote169 views2 answers
Datetime sql server week
SQL
4 votes204 views3 answers
Sqlite show columns
SQL
1 vote212 views1 answer
Delete specific row in sql
SQL
0 vote198 views1 answer
Google sheets filter rows above current cell
SQL
2 votes207 views1 answer
Mysql create user with mysql_native_password
SQL
0 vote205 views1 answer
How to install mysql without admin rights
SQL
0 vote209 views1 answer
Sql select most frequent value in column
SQL
25 votes244 views4 answers
Import mysql dump command line
SQL
0 vote210 views1 answer
Find usage of table in sql server
SQL