/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

9 votes294 views3 answers
Where clause sql
SQL
9 votes284 views2 answers
Nosql databases
SQL
0 vote220 views1 answer
Import csv to mysql
SQL
0 vote255 views1 answer
Get who is hired in january in sql
SQL
23 votes258 views3 answers
Mysqldump
SQL
0 vote274 views1 answer
T-SQL MERGE with condition what is not matched?
SQL
5 votes282 views1 answer
Dbms_metadata.get_ddl table
SQL
0 vote259 views1 answer
Assign value to var in SQL
SQL
1 vote254 views1 answer
How refresh navicat tables to see new tables
SQL
1 vote278 views1 answer
Age postgres
SQL