SELECT ep.schedstatus, bk.LDate, ce.Comments, c.clientid, 
c.LastName,es.EvStrName 'Run', 
ep.City 'P/U City', p.polyname 'P/U County',
ed.City 'Drop-off City',
ed.AddrName 'Facility Name' 
FROM Events ep, Events ed, EventStrings es, Clients c, 
BookingLegs bl, Booking bk, polygons p, address a,
ClientEligConditions ce 
WHERE ep.schedstatus = 3 AND ep.SchId > 288 and ep.SchId < 654 
AND ed.SchId = ep.SchId AND ep.Activity = 0 AND ed.Activity = 1 
AND ed.BookingId = ep.BookingId AND es.SchId = ep.SchId 
AND es.EvStrId = ep.EvStrId 
AND c.ClientId = ep.ClientId 
AND ep.ClientId = ce.ClientId
AND bl.LegId = ep.LegId 
and a.AddrType = CH
and c.DateofBirth > 19871231 and c.DateofBirth < 19940101 
and a.jurispolyid in ('3', '4','7','43','66') 
and a.jurispolyid = p.polyid 
AND ed.BookingId = bk.BookingId 
ORDER BY c. DateofBirth, p.polyname, bk.LDate, es.EvStrName
 
  Management Report Summary
Here are the numbers everyone has been waiting for:

The date filter shows 23 prenatal clients transported in the
age range of 14-17 years old during the 2005 calendar year. 
 
A total of 255 trips were made in 2005 by these 23 clients, some had 
more trips than others. 
 
 
 
 
 
 
 
 
 
 
 
 

 

David Wilkowske.com

Structured Query Language (SQL)


2008-2009 TCJH Media A Division of CCDRW, LLC . All rights reserved unless otherwise stated. No part of this web site may be reproduced or transmitted in any form or by any means, electronic or mechanical, by any information storage or retrieval system without the prior written consent of TCJH Media and/or David R. Wilkowske.

My Motto: I'll Do Just About Anything as Long As It's Safe and Legal