Skip to Content
0
Former Member
Aug 21, 2008 at 04:11 AM

selct stmt with changing where condition

11 Views

Hello All,

I got a req where i have to get records from a Single table where the where clause changes every time

how can i acheive this with a single hit on the table?

please help.

i.e,

select *

from (Table name)

where (Fieldname) = 1

select *

from (Table name)

where (Fieldname) = 2