SELECT ep.schedstatus, bk.LDate, ce.Comments, c.clientid,
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,
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:
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.
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