Select INMSP300.M3OE# as "OEM_NO", INMSP300.M3OEC as "ComprsOE", INMSP300.M3PRD as "PN", INMSP300.M3CLS as "PrdLine", dbo_ECC_APP.OEM[/strong]_NO, dbo_ECC_APP.CARDONE_NO, dbo_ECC_APP.OE_FORMER2, dbo_ECC_APP.OE_REPLACED_BY, dbo_ECC_APP.ID_NO, dbo_ECC_APP.RELEASE
From RDB CARF1.INMSP300 INMSP300l LEFT join RDB dbo_ECC_APP dbo_ECC_APP
, ComprsOE=OEM_N0 --------------- I think this should be something like
ON ComprsOE=OEM_N0 -------------- this ...

Where INMSP300.M3CLS ='78' and INMSP300 is NULL;

C

Do you get any text with the error message?
I would make a very simple select first, then add one item at a time ...
Phil


Found the text up above
SQL thinks you are refering to: dbo_edd_ppp
I don't see it in this code but since this is a query on a query ????

______________________________________

Below is the code that I get.

[IBM][System i Access ODBC Drive][DB2 for i5/OS]sql5001 - Column qualifier or table DBO_ECC_APP undefined. (#-5001)

What I did is I went into accees and the designed a link by joining the different queries together and allowed the software to develop the SQL statement and this is what it came up with.


SELECT dbo_ECC_APP.CARDONE_NO, dbo_ECC_APP.OEM_NO, [78IN0140wOE].M3PRD, [78IN0140wOE].M3PRD
FROM dbo_ECC_APP INNER JOIN 78IN0140wOE ON dbo_ECC_APP.OEM_NO = [78IN0140wOE].[M3OE#];

Why the are there [ ] and what does that do? Why is it only on the table being joined and not the feild?

-----------------
Access will put [ ] around a name that would otherwise confuse it --
- In access you can name a column with a space in it like EMPLOYEE NUMBER to clarify that for SQL it gets
the [EMPLOYEE NUMBER] treatment. So our editor has done something here [78IN0140wOE].[M3OE#] -- it's saying [78IN0140wOE] is a name of a file or column that SQL might have a problem understanding (the wOE in that name probably isn't really wOE and it starts with a digit so it encloses it in [].
It does the same for [M3OE#] -- here it might be the # sign that gets Access a bit excited. As you said it works.
Phil

Please complete the following information:

REGISTER / LOG-IN TO DISCUSS

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Submit your e-mail address below to continue

E-mail: 

E-mail: 

Handle:   

Password: 

Forgot Password?

Create Handle: 

Your handle identifies you in ITKnowledgeExchange. Max 30 char.

Create Password: 

Confirm Password: 

Yes, I agree to the IT Knowledge Exchange  Terms and Conditions.

hidden modal window