Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Incident Reports » Incident Reports Addressed for Version 4.21 » View Incident Report |
Minor |
Reported By: Rob Grundy Reported On: 10/17/2005 For: Version 4.21 Build 10 |
select j.jb_JobNo, MIN(b.CB_Date) as first_ccar, MAX(b.CB_Date) as last_ccar, b.CB_Reg as first_ccreg, a.CB_Reg as current_ccreg from jobs j left outer join bookings b on (j.JB_JobNo=b.CB_JobNo) left outer join bookings a on (j.JB_JobNo=a.CB_JobNo) and (a.CB_Date = Current_date) group by j.JB_JobNo
This web page was last updated on Tuesday, April 23, 2024 at 08:39 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |