Hi list,
I ran into weird problem (MaxDB 7.5.0.30 on Windows). My query with correlated
subquery in select
gives me wrong results. Here is the testcase (very simplified).
DDL:
CREATE TABLE TMP_1 (ID_MAIN FIXED(19) NOT NULL PRIMARY KEY)
CREATE TABLE TMP_2 (ID_1 FIXED(19) NOT NULL, ID_2 FIXED(19
Hi Listmembers,
I try to define a updateable join view with the followin statements:
CREATE TABLE WWIND.KD (
KUNDENNR FIXED(10) default serial PRIMARY KEY,
FIRMA CHAR(40) NOT NULL,
KONTAKTPERSON CHAR(30),
FUNKTION CHAR(30)
)
//
CREATE TABLE WWIND.ADR (
ADRESSNR FIXED(10) PRIMARY KEY,
