FisherM_Acess1 - Matt Fisher- msf463 Fi rst Querty:...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Matt Fisher- msf463 Fi rst Querty: ClientsQuer y ClientName Alpha-Type Shoes Bling Bling Rings Jimmy's Hot Dogs Quickie-Mart SELECT Clients.ClientName FROM EventTypes INNER JOIN (Clients INNER JOIN Events ON Clients.[ClientID] = Events.[Clients_ID]) ON EventTypes.[EventTypeID] = Events.[EventTypes_ID] GROUP BY Clients.ClientName, EventTypes.EventType HAVING (((EventTypes.EventType)="Product Rollout")); Second Querty: CaterersQu ery Caterer Carl's Calzones Fran's Frijoles Rhoda's Rolls SELECT Caterers.Caterer FROM EventTypes INNER JOIN (Caterers INNER JOIN Events ON Caterers.[CatererID] = Events.[Caterers_ID]) ON EventTypes. [EventTypeID] = Events.[EventTypes_ID] GROUP BY Caterers.Caterer, EventTypes.EventType HAVING (((EventTypes.EventType)="Celebratory Function")); Clients ClientName ClientContact ClientPhone EventType EventD Caterer Alpha-Type Logan Walker 512-232-3342 Celebratory Function 2/7/2002 Carl's Calzones Product Rollout 2/10/2002 Rhoda's Rolls Press Conference 2/11/2002 Rhoda's Rolls...
View Full Document

Page1 / 6

FisherM_Acess1 - Matt Fisher- msf463 Fi rst Querty:...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online