/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 vote146 views1 answer
Denormalise SQL command
SQL
15 votes144 views4 answers
Mysql where value is null
SQL
0 vote161 views1 answer
Mysql delete from where like
SQL
0 vote234 views1 answer
ORA-00942
SQL
-1 vote143 views1 answer
Ssms connect with connection string
SQL
3 votes147 views1 answer
Create a table with an id in mysql
SQL
0 vote142 views1 answer
What is between operator
SQL
13 votes141 views5 answers
Alter table query sql server change column
SQL
3 votes158 views2 answers
Oracle apex view logs
SQL
3 votes148 views1 answer
Oracle transaction commit rollback example
SQL