Greetings. I'm trying to execute a DB2 command such as:

SELECT P.ITEM_NO,
D.FILE_NAME
FROM PRODDB2.PART P
LEFT JOIN PRODDB2.DATA D
ON P.OBJ_ID = D.OJB_ID

but I get: "D.OJB_ID" is not valid in the context where it is used.
SQLSTATE=42703

Ah, but OBJ_ID column is type CHAR(30). So I suppose I may need to
match with "like" instead of "=" So I change the last part:
ON P.OBJ_ID LIKE D.OJB_ID

Alas, that doesn't help:
An unexpected token "D" was found following "". Expected tokens
may include: ":". SQLSTATE=42601

What is the proper syntax for a join on a non-numeric column?

Thanks!

"DavidFilmer" <usenet (AT) davidfilmer (DOT) com> wrote

No difference for non-numeric columns. Please post DDL for the tables and
indicate the schema names of the tables.

Is it intended or is it a typo that you have two different field names
there, OJB and OBJ?

On Mar 10, 4:14*pm, "Mark A" <no... (AT) nowhere (DOT) com> wrote:

On Mar 11, 2:32 am, DavidFilmer <use... (AT) davidfilmer (DOT) com> wrote:
Where you partly drunk when you typed this or was it a typo when you
wrote the question? You have used OJB_id instead of OBJ_ID referring
to the table 'D'.

Arun Srini wrote:

Now all who have never searched hours for a typo that some smart alec who
just dropped by spots instantly please raise you hands ;-)

--
Will Honea