Link between string & Numeric field

[Wilfrieds]

Hey,

I try to make a link between 2 tables. Where in the first table the field is Nummeric and 9 char. long and in the second table the field is a string a 10 char. long. Making the link is no problem. But when I try to place both fields on my report, I have the following errror:BDB error(301): Query not correct & Error detected by database DLL.
Query :
SELECT
tdcms600.auft,
tdsls045.orno
FROM
tdcms600,
tdsls045
WHERE
tdcms600.auft=tdsls045.orno

I work with CR 8.5 and with BaaN 4C4

What the is the problem

 

[Naith]

I've never touched Baan before, but if you can convert the string field to a numeric, or the numeric to a string in the SQL, then I don't think you'll have a problem in the report.

Naith