No unfortunately we contracted the design of this particular system out to a company. I actually need line 3. When i first had it in SQL Server, I had an INNER...

Fred--SQL Plus is the interface packaged with Oracle (at least the version we've been given to play with) and allows me to interface with the Oracle db directly.

SELECT wo.WORKTYPE,...

Yes, that's correct. Maximo is both the database name on the EMAXDEC1 server and owner. Ok, thanks for the info--back to the drawing board.

The database name is Maximo. When I don't use the WORKORDER table, I connect just fine. The WORKORDER table is the issue because it's just huge in size. 217 columns...