select sentence to join different servers tables...

From: nuria (nuriavadillo_at_cbl.es)
Date: 03/17/05 

Date: 17 Mar 2005 09:36:08 -0800

hi

I have an AS400 table and SQL server table and need do a JOIN in a
select, I did this:

SELECT GNORP.COORG, GNORG.ORDES, GNORP.CPAIS, GNPAI.PADES, GNORP.ORV01
FROM ((GNORP GNORP LEFT OUTER JOIN GNORG GNORG ON GNORP.COORG =
GNORG.COORG) LEFT OUTER JOIN SERVIDOR_CBL.GN_3_0.dbo.GNPAI GNPAI ON
GNORP.CPAIS = GNPAI.COPAI) ORDER BY GNORP.COORG, GNORP.CPAIS

in this case "SERVIDOR_CBL.GN_3_0.dbo.GNPAI" I said the
serverName.BDName.Owner.TableName

But give me an error... Anyone know how can I do this??

Thanks in advance...

Relevant Pages

  • Re: LEFT OUTER JOIN possible in DB2?
    ... i was trying to get a customer to create a view on their IBM thingy. ... Now, OS/400 comes with its own DBMS, which I assume is at a lower level that an RDBMS, like DB2 or SQL Server. ... > Turns out a LEFT OUTER join is sorta possible in IBM/DB2/AS/400. ...
    (microsoft.public.sqlserver.programming)
  • Re: Flattening Parent Child, an issue, please help
    ... AND t2.WBS_LEVEL = 2 LEFT OUTER JOIN ... I am using SQL Server 2000 with SP4. ... For information about dyamic SQL from T-SQL see ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: Flattening Parent Child, an issue, please help
    ... in future when all divisions would start using Project Module. ... AND t2.WBS_LEVEL = 2 LEFT OUTER JOIN ... I am using SQL Server 2000 with SP4. ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: How to query with both JOIN and aliases in Access?
    ... v.empID LEFT OUTER JOIN FirstDayWorked FROM ... This query performs in SQL Server without any problem. ... LEFT OUTER JOIN (SELECT empID, ...
    (microsoft.public.access.queries)
  • Re: Updating linked tables
    ... An outer join is the way to go... ... I support the Professional Association of SQL Server and it's community of SQL Server professionals. ... > I have a users table that stores basic information for all users. ... > FirstName VARCHAR NOT NULL, ...
    (microsoft.public.sqlserver.server)