sql query use select name inside where clause

Solutions on MaxInterview for sql query use select name inside where clause by the best coders in the world

Search
showing results for - "sql query use select name inside where clause"
Sofia
11 May 2019
1You can not use aliased columns in a WHERE clause. You can try using a derived
2table. Perhaps something like this (sorry, not tested):
3
4select tblProgram.POIname from tblProgram
5where 
6  -- Use this if you only want to filter by the value.
7  (select count(*) as alias_name from `fb_promo_codes_used`) < 2
similar questions
find table from column name in sqlsql find table by namehow to find names includes in sqlsql select where in listselect 2a from table where name likeselect in select sqlwhere query in sql serversql where klauselselect a field from another table sql as fieldsql query to return field name of a tableselect query where in sqlsql select inside select sub querysql select rows with simlar nameshow to find sql server namewhere clause sqlsql select column name like from multiple tablesselect query in sqlsql where keywordwhere keyword sqlt sql find object by namesql server find table name
queries leading to this page
select where selectwhere clause other than one valueand condition and suberuy sqlsql using subquery result in where clausecheck all the data in subquery that is equal to one value in sqlsql subquery in where conditionwhere in result of select sqlhow to add select query in where clausesql query use select name inside where clausesql subquery with where clausewrite select clause within where in sqlhow to write select query in where clausesubquery whereusing a select statement in a where clausenested sql query where clausemake a subquery with where clause comparing outer selectsun query in where condiionselect inside where clausewhere with select sqlstore the value of a sql subquery and use it in outter queryselect in where clause sql serversql query use select name inside where clause