where with select sql code example

Example 1: where id is in list sql

select * from table where id in (id1,id2.........long list)

Example 2: 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

Tags:

Sql Example

Related