/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 vote126 views1 answer
List column names of multiple tables psql
SQL
2 votes133 views1 answer
Sql server check for value in multiple columns
SQL
0 vote133 views1 answer
Mysql add root password
SQL
1 vote154 views1 answer
Mysql previous year
SQL
0 vote149 views1 answer
Select count concat string sql server
SQL
1 vote125 views1 answer
Incompatible sql_mode=only_full_group_by
SQL
0 vote127 views1 answer
Sql select merge multiple values
SQL
22 votes136 views3 answers
Remove all records from table mysql
SQL
0 vote120 views1 answer
Product of a column in mysql
SQL
9 votes120 views4 answers
Add primary key to existing table sql
SQL