/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 vote165 views1 answer
Replace multiple string in query sql
SQL
1 vote162 views1 answer
How to get mysql db size
SQL
0 vote189 views1 answer
Change filed order in mysql
SQL
16 votes178 views4 answers
Mysql import from sql file
SQL
0 vote174 views1 answer
Mysql 8 geo to json
SQL
0 vote209 views2 answers
Mysql where in maintain order group_concat
SQL
3 votes237 views1 answer
Apex call duration
SQL
0 vote164 views1 answer
How to reset table in sql server
SQL
0 vote173 views1 answer
Error: connect ECONNREFUSED 127.0.0.1:5432 at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1148:16
SQL
42 votes265 views6 answers
Rename table sql server
SQL