topic Re: Doubt in select query in Application Development and Automation Discussions

Doubt in select query

Former Member — Wed, 20 Feb 2008 07:04:56 GMT

hello friends , i have one simple doubt

tables:plpo,plfh.

select * from plpo

where plnty = 'N'

and plnNR = group_number "'CEWGRP'

and vornr = W_ASSIGN_PRT-OPERATION_NUMBER.

endselect.

select * from plfh where

plnty = 'N'

and plnnr = group_number

and plnkn = plpo-plnkn

and loekz = 'x'.

endselect.

for the last select query i want that query should take records with both loekz = 'x' and loekz ne 'x' ..so waht can i do without changing any field above loekz....might be something like

(where loekz id deletion indicator)

select * from plfh where

plnty = 'N'

and plnnr = group_number

and plnkn = plpo-plnkn

and loekz = 'x' or loekz ne 'x'...is something like this possible?means it shd take into consideration both records with x and without x.

Re: Doubt in select query

Former Member — Wed, 20 Feb 2008 07:06:41 GMT

Hi,

Don't take that field in where condition.

Re: Doubt in select query

Former Member — Wed, 20 Feb 2008 07:08:47 GMT

Yes You can use that... but what is the necessity to include both with 'X' and ' '.

instead u can use loekx = 'X' or loekx = ' '.

Re: Doubt in select query

Former Member — Wed, 20 Feb 2008 07:10:00 GMT

Hello,

loekz is a deletion indicator. So it can have value 'X' or space.

In order to pick up records you can ignore loekz from select query.

Regards,

preeti.

Re: Doubt in select query

former_member195383 — Wed, 20 Feb 2008 07:10:01 GMT

Remove loekz from ur select query.So irrespective of loekz value,it ll select the data

select * from plfh where

plnty = 'N'

and plnnr = group_number

and plnkn = plpo-plnkn

will work....

Reward if useful.

Regards

Rudra

Re: Doubt in select query

Former Member — Wed, 20 Feb 2008 07:14:34 GMT

Hi,

You can write in 3 ways.

select * from plfh where

plnty = 'N'

and plnnr = group_number

and plnkn = plpo-plnkn

and ( loekz = 'x' or loekz EQ '' ).

2. select * from plfh where

plnty = 'N'

and plnnr = group_number

and plnkn = plpo-plnkn

and loekz IN ( 'x' ,' ' ).

select * from plfh where

plnty = 'N'

and plnnr = group_number

and plnkn = plpo-plnkn.

Re: Doubt in select query

Former Member — Wed, 20 Feb 2008 07:31:10 GMT

hi ,

Dont take that field in ur where condition if u want to have both the values x and space.

if there are some other values for that field other than X and space ,u should write

field ='X' or field = space in where clause.

pls reward if helpful.

regards,

Deepa

Re: Doubt in select query

Former Member — Wed, 20 Feb 2008 07:51:21 GMT

thanks a lot muralikrishna k.

it was a very nice answer by u which helped me to solve my problem.

and thank u all for replying to my thread.