/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 vote140 views1 answer
Mysql query single row
SQL
0 vote158 views1 answer
What does the -p flag do in mysql cli
SQL
0 vote149 views1 answer
Sql combine results from two tables
SQL
2 votes154 views5 answers
Eloquest how to select one specific column in database
SQL
0 vote159 views1 answer
Mysql min value row
SQL
0 vote142 views1 answer
Mysql a from on this page has
SQL
0 vote162 views1 answer
Leftjoin in sql
SQL
0 vote138 views1 answer
What is the difference between the LIKE and REGEXP operators in mysql?
SQL
3 votes157 views1 answer
Where id is in list sql
SQL
4 votes141 views1 answer
Oracle select first 10 rows
SQL