469,319 Members | 2,429 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,319 developers. It's quick & easy.

outer joins in MSSQL

migrated databases from sybase to mssql, migration exported sybase written
queries written with the application build in query tool and imported to mssql
databases. all db and tables migrated without errors. Regular queries without
outer joins work fine but the outer join queries are failing with the following message: Microsoft ODBC SQL Server Driver SQL Server Query contain an
outer-join request that is not permitted. I think the MSSQL join the was passed
from sybase to mssql does not like the *.
WHERE (B.processing_yr =2007 AND B.ldr_entity_id ='111')
AND (C.ldr_entity_id*=A.ldr_entity_id AND B.ldr_entity_id*=C.ldr_entity_id AND B.ull_prime*=C.ull_prime)

Can I replace the * with something that mssql recogonizes as a outer join.
Thanks
Sep 25 '07 #1
1 2475
ck9663
2,878 Expert 2GB
migrated databases from sybase to mssql, migration exported sybase written
queries written with the application build in query tool and imported to mssql
databases. all db and tables migrated without errors. Regular queries without
outer joins work fine but the outer join queries are failing with the following message: Microsoft ODBC SQL Server Driver SQL Server Query contain an
outer-join request that is not permitted. I think the MSSQL join the was passed
from sybase to mssql does not like the *.
WHERE (B.processing_yr =2007 AND B.ldr_entity_id ='111')
AND (C.ldr_entity_id*=A.ldr_entity_id AND B.ldr_entity_id*=C.ldr_entity_id AND B.ull_prime*=C.ull_prime)

Can I replace the * with something that mssql recogonizes as a outer join.
Thanks
try something like

Expand|Select|Wrap|Line Numbers
  1. select c,blah, b.blah, a.blah
  2.  
  3. FROM tableC C left outer join TableA on C.ldr_entity_id =A.ldr_entity_id
  4.     right outer join tableB on B.ldr_entity_id*=C.ldr_entity_id AND B.ull_prime*=C.ull_prime
  5.  
  6. WHERE (B.processing_yr =2007 AND B.ldr_entity_id ='111')
  7.  
  8.  
Sep 25 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by Martin | last post: by
8 posts views Thread by Matt | last post: by
4 posts views Thread by Anthony Robinson | last post: by
3 posts views Thread by Ian Boyd | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by mdpf | last post: by
reply views Thread by listenups61195 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.