/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

5 votes128 views2 answers
Mysql create database charset utf8mb4
SQL
0 vote111 views1 answer
Postgres truncate with cascade
SQL
1 vote112 views1 answer
Flask sqlalchemy filter multiple conditions
SQL
0 vote103 views1 answer
Mysql calculated column
SQL
0 vote122 views2 answers
Starts and end with vowel sql
SQL
6 votes97 views2 answers
Find mysql version linux
SQL
0 vote135 views1 answer
Sp help text in postgresql
SQL
1 vote117 views1 answer
Print year of a date sql
SQL
0 vote110 views1 answer
Drop-toys-table
SQL
7 votes111 views3 answers
Postgre describe table
SQL