Can anyone help me?

[Ana Maria <anamaria@MIPS-SISTEMAS.COM.BR>]

HI!!!

My name is Ana Maria and I am from Brazil.

I?ve just done my first SQR programs and they are working properly, when
they are running on SQLBase database. Both on WorkBench and in MAXIMO
application (after being compiled).

But when trying to run on SQLServer, an error occurs. It always happens on
the same kind of select: when there is more than one database refered in
the from clause.

(SQR 5528) ODBC SQL dbsql: SQLPrepare error 107 in cursor 1:
   [Microsoft][ODBC SQL Server Driver][SQL Server]The column prefix
'WORKORDER' does not match with a table name or alias name used in the
query.
SQL:  select distinct WORKORDER.WONUM, WORKORDER.DESCRIPTION,
      WORKORDER.LOCATION, WORKORDER.JPNUM, pm.PMJP6  from workorder
workorder,
      pm pm

I tryed to use alias names (as shown above), but the error persists.

Here is an exemple:

Begin-Select distinct

WORKORDER.WONUM                         &wonum
WORKORDER.DESCRIPTION           &wodesc
WORKORDER.LOCATION                      &woloc
WORKORDER.JPNUM                         &jpnum
pm.PMJP6                                        &reqparada
.......



from workorder, pm


[Ana Maria Neves]