/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

11 votes209 views2 answers
Mysql disable safe mode
SQL
25 votes223 views4 answers
Sqlserver add column
SQL
0 vote221 views1 answer
Simple plsql program run in oracle sql developer but got the error
SQL
0 vote218 views1 answer
Error in connection_import_file(conn@ptr, name, value, sep, eol, skip) : RS_sqlite_import: test.csv line 2 expected 11 columns of data but found 1
SQL
8 votes219 views2 answers
How to fetch data from database without last column
SQL
0 vote223 views1 answer
Drop column from local database postgres pgadmin
SQL
2 votes248 views3 answers
Sqlite3.OperationalError: near "7": syntax error
SQL
0 vote215 views1 answer
Sql trying to delete database in use
SQL
0 vote223 views1 answer
Mysql dump everythign
SQL
1 vote218 views1 answer
Mysql list bigger table
SQL