Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Incident Reports » Incident Reports Addressed for Version 4.20 » View Incident Report |
Serious |
Reported By: Frank Fischer Reported On: 4/12/2005 For: Version 4.19 Build 1 |
SELECT ANREDE, STRASSE, PLZ, ORT, TEL, FIRMA, TKd.KD_ID AS KD_ID, TKd.KD_ID AS TKdKD_ID, TKd.Bemerk, TKSStat_ID, IF(KD_Nr=NULL THEN Name || ' ' || Vorname ELSE Name || ' ' || Vorname || ' - Knd.Nr.: ' || KD_Nr) AS Kunde INTO MEMORY\TMEMKd FROM TKd LEFT OUTER JOIN TKdStat ON (KD_ID = TKSKD_ID AND (TKSStat_ID = 1 or TKSStat_ID = 4)); SELECT TMEMKd.*, TVertr.Kd_ID AS VertrKD_ID, TVertr.VArtInd, TVertr. VertrArt FROM MEMORY\TMEMKd Left OUTER JOIN TVertr ON (TKdKd_ID = TVertr.Kd_ID) WHERE (TKSStat_ID = NULL ) GROUP BY TKdKD_ID;
This web page was last updated on Wednesday, March 20, 2024 at 07:22 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |