where id is in list sql
select * from table where id in (id1,id2.........long list)where id is in list sql
select * from table where id in (id1,id2.........long list)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`) < 2Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
