Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Incident Reports » Incident Reports Reported for Version 4.05 » View Incident Report |
Minor |
Reported By: Thad Smith Reported On: 4/13/2004 For: Version 4.05 Build 1 |
SELECT M.IndvID, M.Group_ID, M.Reserve_ID, M.Mark_Year, M.Event_ID, IF (G.Master_ID = 0 THEN EXTRACT(MONTH FROM MA2.Group_Start) ELSE EXTRACT(MONTH FROM MA.Group_Start) ) AS Start_Month FROM awgrmark M JOIN awgrgrp G ON (M.Group_ID = G.Group_ID) LEFT OUTER JOIN awgrgrma MA ON (G.Master_ID = MA.Group_ID) LEFT OUTER JOIN awgrgrma MA2 ON (G.Group_ID = MA2.Group_ID) WHERE IF(G.Master_ID=0 THEN M.Group_ID = 4 ELSE G.Master_ID = 4) Workaround: SELECT M.IndvID, M.Group_ID, M.Reserve_ID, M.Mark_Year, M.Event_ID, IF (G.Master_ID = 0 THEN EXTRACT(MONTH FROM MA2.Group_Start) ELSE EXTRACT(MONTH FROM MA.Group_Start) ) AS Start_Month FROM awgrmark M JOIN awgrgrp G ON (M.Group_ID = G.Group_ID) LEFT OUTER JOIN awgrgrma MA ON (G.Master_ID = MA.Group_ID) LEFT OUTER JOIN awgrgrma MA2 ON (G.Group_ID = MA2.Group_ID) WHERE IF(G.Master_ID=0 THEN M.Group_ID ELSE G.Master_ID )=4
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 |