S92 Inner Join

[arobbo]

Hi guys , sorry this one might be a bit simple ,

tried to avoid Inner Joins in Progress but now I want to try one out can't get the syntax right.

Could someone point out my error please

Select name From Pub.arsc Inner Join Pub.oeeh on arsc.custno = oeeh.custno where cono = 1

Error I'm getting is

[DataDirect][ODBC PROGRESS driver][PROGRESS]Column ambiguously specified (7523)

Any help would be much appreciated

Cheers

Andy

 

[tamhas]

First thing I would do is to put Pub qualifications on everything, not just some and qualify the field names with table names in all places.