/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 vote281 views1 answer
Redirection 301 htaccess nom de domaine
SQL
15 votes292 views6 answers
Drop foreign key mysql
SQL
5 votes285 views2 answers
Mysql drop table cascade
SQL
0 vote254 views1 answer
Java spring boot connect to sql server
SQL
2 votes289 views1 answer
Sql server find table name
SQL
0 vote259 views1 answer
Select all domains of database firbird
SQL
0 vote297 views1 answer
Mysql bind-address default value
SQL
0 vote294 views1 answer
Error: connect ECONNREFUSED 127.0.0.1:5432 at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1148:16
SQL
0 vote307 views1 answer
Convert multiple columns to ROws in sql server
SQL
0 vote268 views1 answer
Mysql date + 1 day
SQL