Hi all!

I have a problem with a SQL query, can't seem to get it working.

description:
I have 4 tables in a DB2 environment, accessing from a external environment (Notrix) using SQL, I want to link these tables based on the Column 'IDNumber'.
From the first table I want to make a selection based on several codes in the column 'CodeNumber', codenumber=002 and codenumber=004. For all rows that match the codenumber in table 1 collect information from the other 3 tables (based on IDNumber).

First I join the 4 tables, based on the IDNumber column, then make the selection

Here is my SQL query for the selection:
SELECT QQ.Table1.IDNumber, QQ.Table1.C1, QQ.Table1.C2, QQ.Table1.CodeNumber, QQ.Table2.CodeNumber,QQ.Table2.IDNumber, QQ.Table2.C3, QQ.Table3.CodeNumber, QQ.Table3.IDNumber, QQ.Table2.C4, QQ.Table4.IDNumber, QQ.Table4.CodeNumber, QQ.Table2.C5
FROM
QQ.Table1,
QQ.Table2,
QQ.Table3,
QQ.Table4
WHERE
QQ.Table1.IDNumber = QQ.Table2.IDNumber AND
QQ.Table1.IDNumber = QQ.Tabel3.IDNumber AND
QQ.Table1.IDNumber = QQ.Tabel4.IDNumber AND
(QQ.Table1.CodeNumber = 002 OR QQ.Table1.CodeNumber = 002)

I get the following errormessage:
SQL0401N The data types of the operands for the operation "" are not compatible. SQLSTATE=42818

Hope someone can help me.

Thanks!

Michel

Something like following is much closer to truth:

Lenny

If the received error message is exactly same as above(especially operation ""),
check and compare data types of columns used in your query.

For example:
1) Compare data types of QQ.Table1.IDNumber, QQ.Table2.IDNumber, QQ.Table3.IDNumber and QQ.Table4.IDNumber
2) Is data type of QQ.Table1.CodeNumber numeric?