Boat Dealer Wisconsin Gage Boats
      Sun Apr 23, 2017 6:30 pm 
Hello!  Guest  My Account  |  Sign In or Create Account
Error 42704:EVENTTYP in *LIBL type *FILE not found. SQLCODE=-204
SELECT EVENTHDR.EHCOMP, EVENTHDR.EHEKEY, EVENTHDR.EHEVNT, EVENTHDR.EHBDAT, EVENTHDR.EHBTIM, EVENTHDR.EHETIM, EVENTHDR.EHSTAT, EVENTHDR.EHPRVT, EVENTHDR.EHWDAT, EVENTHDR.EHWTIM, EVENTRES.ERRESC, EVENTTYP.ETLDES, EVENTOVR.EOLDES, RESCMAST.RMLDES, EVENTALC.EAALLC, ifnull(max(case when EAAPRO = 'SEAT' then (EAALLC - EASETS - EASOLD - EASTND - EAHELD) else null end), 'No seat') as "SEAT" FROM EVENTTYP left join EVENTHDR on EVENTTYP.ETCOMP = EVENTHDR.EHCOMP and EVENTTYP.ETETYP = EVENTHDR.EHEVNT left join EVENTOVR on EVENTHDR.EHCOMP = EVENTOVR.EOCOMP and EVENTHDR.EHEKEY = EVENTOVR.EOEKEY inner join EVENTRES on EVENTHDR.EHCOMP = EVENTRES.ERCOMP and EVENTHDR.EHEKEY = EVENTRES.EREKEY inner join RESCMAST on EVENTRES.ERCOMP = RESCMAST.RMCOMP and EVENTRES.ERRESC = RESCMAST.RMRESC inner join EVENTALC on EVENTHDR.EHCOMP = EVENTALC.EACOMP and EVENTHDR.EHEKEY = EVENTALC.EAEKEY where EHPRVT !='Y' and (EHSTAT = 'O' or EHSTAT = 'W' or EHSTAT = 'D') and (((EHBDAT = 20170423) and (EHBTIM >= 1830)) or (EHBDAT <> 20170423)) and EVENTHDR.EHBDAT = '20170423' group by EVENTHDR.EHCOMP, EVENTHDR.EHEKEY, EVENTHDR.EHEVNT, EVENTHDR.EHBDAT, EVENTHDR.EHBTIM, EVENTHDR.EHETIM, EVENTHDR.EHSTAT, EVENTHDR.EHPRVT, EVENTHDR.EHWDAT, EVENTHDR.EHWTIM, EVENTRES.ERRESC, EVENTTYP.ETLDES, EVENTOVR.EOLDES, RESCMAST.RMLDES, EVENTALC.EAALLC order by EHCOMP , EHBDAT , EHBTIM , EHEKEY FETCH FIRST 20 ROWS ONLY
Tours available on  Sun Apr 23, 2017
  Time   Tour Description   Boat Name Status