/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 vote222 views3 answers
Postgresql allow remote connections
SQL
6 votes213 views2 answers
Sql query to get the number of rows in a table
SQL
3 votes200 views2 answers
Sql asc
SQL
1 vote204 views1 answer
Round function in sql oracle
SQL
0 vote202 views1 answer
Restore backupfile discourse
SQL
53 votes583 views6 answers
Sql server alter column
SQL
0 vote214 views1 answer
Sqlite insert or update
SQL
3 votes219 views2 answers
See mysql users ubuntu
SQL
0 vote220 views2 answers
Insert data mysql with cmd
SQL
1 vote221 views1 answer
DoVerify() must be an instance of Lcobucci\\JWT\\Signer\\Key
SQL