/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 vote360 views1 answer
Run mysql xampp shell
SQL
0 vote374 views1 answer
Load data infile mariadb slow
SQL
2 votes364 views1 answer
Codeigniter print last sql query
SQL
0 vote346 views1 answer
Pgadmin see indexes
SQL
0 vote329 views1 answer
Sql query for select from specific columns in a table
SQL
2 votes326 views1 answer
Mysql list users on ubuntu
SQL
58 votes603 views4 answers
Mysql drop column
SQL
-1 vote338 views2 answers
REMOVE DATE FROM DATE TIME SQL SERVER
SQL
1 vote336 views1 answer
Oracle list datafiles in tablespace
SQL
1 vote370 views2 answers
Mysql switch case
SQL