Re: HELP: SQL SELECT
From: Craig Sivils <csivils_at_blkbox.com>
Date: 1995/10/24
Message-ID: <DGyL8M.L3q_at_twisto.eng.hou.compaq.com>#1/1
Date: 1995/10/24
Message-ID: <DGyL8M.L3q_at_twisto.eng.hou.compaq.com>#1/1
snufupagus_at_aol.com (Snufupagus) wrote:
>select * from pt_code where diag_cod = '621.100'
>union
>select * from pt_code where diag_cod = '303.500'
>union
>select * from pt_code where diag_cod = '339.000'
The self join of the table to itself 3 times would work. The count distinct with the having > 3 clause would work if written correctly. And the above would have worked if they had used intersect rather than union.
Craig Received on Tue Oct 24 1995 - 00:00:00 CET