PL/SQL Question
ChoMan23Jan 25 2012 — edited Jan 25 2012Create Table Test(
ID Number
MedName VARCHAR(2),
Date date,
)
insert into Test
VALUES 1,'Benadryl','12/31/2012'
insert into Test
VALUES 1,'Tylenol','12/10/2012'
insert into Test
VALUES 1,'Ibroprofen','12/31/2012'
What I am trying to do is show records that have received both Benadryl and Tylenol for the same ID and date. Any help would be appreciated. I am using Oracle 11g.
Edited by: 792208 on Jan 25, 2012 6:39 AM
Edited by: 792208 on Jan 25, 2012 6:42 AM