/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 vote352 views1 answer
Having all mysql
SQL
10 votes348 views5 answers
Create table mysql query
SQL
1 vote300 views2 answers
Mysql spring boot application.properties
SQL
-1 vote326 views3 answers
How to restart mysql in linux
SQL
0 vote335 views5 answers
ABC TO FLEX BATTLE IM POOR
SQL
10 votes286 views2 answers
Sql where clause multiple values
SQL
0 vote322 views1 answer
Starting mysql shell lampp ubuntu
SQL
0 vote299 views1 answer
Getting next sequence value jpa postgress
SQL
0 vote301 views1 answer
Mysql delete from where like
SQL
0 vote314 views1 answer
Sql server python connection
SQL