Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Incident Reports » Incident Reports Addressed for Version 3.21 » View Incident Report |
Serious |
Reported By: Ole Willy Tuv Reported On: 12/12/2002 For: Version 3.20 Build 1 |
DROP TABLE IF EXISTS MEMORY Table1; CREATE TABLE MEMORY Table1 ( c1 CHAR(1), c2 CHAR(1), c3 CHAR(1), PRIMARY KEY (c1) ); INSERT INTO MEMORY Table1 VALUES('1', 'a', 'a'); INSERT INTO MEMORY Table1 VALUES('2', 'b', 'b'); INSERT INTO MEMORY Table1 VALUES('3', 'c', 'c'); INSERT INTO MEMORY Table1 VALUES('4', 'd', 'd'); DROP TABLE IF EXISTS MEMORY Table2; CREATE TABLE MEMORY Table2 ( c1 CHAR(1), c2 CHAR(1), c3 CHAR(1), PRIMARY KEY (c1) ); INSERT INTO MEMORY Table2 VALUES('1', 'a', 'a'); INSERT INTO MEMORY Table2 VALUES('2', 'b', 'b'); INSERT INTO MEMORY Table2 VALUES('3', 'e', 'e'); SELECT c1, c2, c3 FROM MEMORY Table1 WHERE c2||c3 NOT IN (SELECT c2||c3 FROM MEMORY Table2) UNION SELECT c1, c2, c3 FROM MEMORY Table2 WHERE c2||c3 NOT IN (SELECT c2||c3 FROM MEMORY Table1)
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 |