/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

2 votes162 views1 answer
How to select first row of database sql
SQL
6 votes166 views1 answer
Oracle trigger after connect
SQL
0 vote188 views1 answer
Kill mysqld_safe process mariadb
SQL
3 votes172 views2 answers
Get current year sql
SQL
0 vote281 views3 answers
Insert or ignore postgres
SQL
0 vote158 views2 answers
Clear window pl sql
SQL
0 vote171 views1 answer
Mysql:5.6 syntax create table
SQL
0 vote191 views1 answer
Into operator in sql
SQL
0 vote230 views1 answer
Cannot start database server xampp mac os
SQL
0 vote175 views2 answers
Homebrew nysql launch
SQL