Re: HELP: SQL SELECT

Another way to do it is

select card_no from pt_code where diag_cod = '&&dc1' intersect
select card_no from pt_code where diag_cod = nvl('&&dc2','&&dc1') intersect
select card_no from pt_code where diag_cod = nvl('&&dc3',nvl('&&dc2','&&dc1'))
/
undefine dc1
undefine dc2
undefine dc3

input 621.10 in the first variable and leave the others null you get all card_no
with a diag_code of 621.10
input 621.10 in dc1 and 339.00 in the second and leave dc3 null you get all card_no with both.
input 621.10 in dc1 and 339.00 in dc2 and 305.00 in dc3 gets you all cards with all three variables

Ken Received on Thu Oct 19 1995 - 00:00:00 CET