/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 vote98 views1 answer
Print orcale
SQL
2 votes103 views1 answer
Drop all database tables oracle sql developer
SQL
9 votes106 views3 answers
Oracle undo usage by session
SQL
11 votes121 views1 answer
Oracle export view ddl
SQL
0 vote107 views1 answer
Less than date query sqlachemy
SQL
0 vote96 views1 answer
Power bi find all ids not in other tables
SQL
0 vote103 views1 answer
Sql not exists
SQL
0 vote93 views1 answer
Mysql sum per week
SQL
1 vote105 views1 answer
STOP message of how many rows affected sql
SQL
0 vote114 views1 answer
Sql server remove primary key without dropping table
SQL