sql help needed -

Hi there;

I am trying to do the following query and am having a lot of trouble.

Immunization Table = [id#](person who got shot), [type] (type of vaccine give), [date] (date vaccine given)

1)look at all the [id#] who got a shot type "DTaP-Hib" 2)take all the shots they got of [type] = DTP or DTP-Hib or DTaP or DTaP-Hib or DT or Td and order them by ascending date 3)which [id#]s got a shot of type DTaP-Hib as the first or second or third shot

I could do this in procedural code but SQL, tough.

any ideas;
jbt Received on Wed Sep 30 1998 - 09:18:36 CDT