Two Queries

  • Thread starter Thread starter Saz
  • Start date Start date
S

Saz

I have two queries

Query1_Equal

SELECT ER.*, IP.*
FROM ER, IP
WHERE ER.SERVICE_DATE=IP.ADMIT_DATE AND
ER.COMMON_MBR_ID=IP.COMMON_MBR_ID;

And

Query2_MinusOne

SELECT ER.*, IP.*
FROM ER, IP
WHERE ER.SERVICE_DATE=(IP.ADMIT_DATE-1) AND
ER.COMMON_MBR_ID=IP.COMMON_MBR_ID;

Can I combine this two queries?

I am trying to get the record where <ER.SERVICE_DATE=IP.ADMIT_DATE or
ER.SERVICE_DATE=(IP.ADMIT_DATE-1)> AND
ER.COMMON_MBR_ID=IP.COMMON_MBR_ID;.............so Please help me if we
can achieve this goal by just writing one single query.

Thank you,
SB
 
SELECT ER.*, IP.*
FROM ER, IP
WHERE (ER.SERVICE_DATE=IP.ADMIT_DATE AND
ER.COMMON_MBR_ID=IP.COMMON_MBR_ID)
OR
(ER.SERVICE_DATE=(IP.ADMIT_DATE-1) AND
ER.COMMON_MBR_ID=IP.COMMON_MBR_ID)


or even shorter

SELECT ER.*, IP.*
FROM ER, IP
WHERE (ER.SERVICE_DATE=IP.ADMIT_DATE OR
ER.SERVICE_DATE=(IP.ADMIT_DATE-1)) AND
ER.COMMON_MBR_ID=IP.COMMON_MBR_ID
--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
SELECT ER.*, IP.*
FROM ER, IP
WHERE (ER.SERVICE_DATE=IP.ADMIT_DATE AND
ER.COMMON_MBR_ID=IP.COMMON_MBR_ID)
OR
(ER.SERVICE_DATE=(IP.ADMIT_DATE-1) AND
ER.COMMON_MBR_ID=IP.COMMON_MBR_ID)

or even shorter

SELECT ER.*, IP.*
FROM ER, IP
WHERE (ER.SERVICE_DATE=IP.ADMIT_DATE OR
ER.SERVICE_DATE=(IP.ADMIT_DATE-1)) AND
ER.COMMON_MBR_ID=IP.COMMON_MBR_ID
--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
.









- Show quoted text -
Click to expand...

Thank you John. =)
 
Back
Top