Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

sql2005 Expand / Collapse
Author
Message
Posted Tuesday, January 15, 2013 8:31 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, June 6, 2013 10:53 AM
Points: 36, Visits: 76
when i try to execute a query i got this message

Joined tables cannot be specified in a query containing outer join operators. View or function 'CRV_PRODUCTOS' contains joined tables.

someone can help me please.
Post #1407296
Posted Tuesday, January 15, 2013 8:42 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 8:34 AM
Points: 5,222, Visits: 5,079
Do you have the old style joins in the query or the object crv_productos

*= or =*




Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1407303
Posted Tuesday, January 15, 2013 8:49 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, June 6, 2013 10:53 AM
Points: 36, Visits: 76
of course i got *= in my query but i use left outer join in the view crv_productos
Post #1407307
Posted Tuesday, January 15, 2013 8:54 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 8:34 AM
Points: 5,222, Visits: 5,079
From what I have read on the error your getting, it is because you are mixing the two types of join.

*= and =* are only included for backwards compatability with sql2000 and db compat level 80

You should be using the full join clauses like INNER JOIN, LEFT OUTER JOIN etc instead.




Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1407310
Posted Tuesday, January 15, 2013 9:15 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, June 6, 2013 10:53 AM
Points: 36, Visits: 76
if i got this query how i can replace it by left outer join

SELECT c_cliente = rtrim( CR_CLIENTE.crcli_apellidos ) + ' ' + rtrim( CR_CLIENTE.crcli_nombres ),
FROM CR_CREDITOS,
CR_CLIENTE,
CR_OFICINAS,
CR_LISTAS CR_LISTAS_a,
CR_FORMATO,
CR_LISTAS CR_LISTAS_b,
CR_USUARIO,
CR_USUARIO CA,
CR_AGENTE,
CRV_PRODUCTOS ,CR_SOLICITUDES , CR_PRODUCTOS
WHERE ( CR_CREDITOS.crcre_cliente = CR_CLIENTE.crcli_id ) and
( CR_CREDITOS.crcre_operacion = CR_SOLICITUDES.crsol_operacion ) and
( CR_OFICINAS.crofi_sucursal = CR_CREDITOS.crcre_sucursal ) and
( CR_OFICINAS.crofi_oficina = CR_CREDITOS.crcre_oficina ) and
( CR_CREDITOS.crcre_moneda = CR_FORMATO.crfm_codigo ) and
( CR_CREDITOS.crcre_forma_pago *= CR_LISTAS_a.crlis_numero ) and
Post #1407327
Posted Wednesday, January 16, 2013 1:41 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 8:34 AM
Points: 5,222, Visits: 5,079
Completly re-write it

SELECT
....
FROM
....
INNER JOIN --=
.....
ON ..... = .....
LEFT OUTER JOIN --*=
ON ..... = .....
RIGHT OUTER JOIN --=*
ON ..... = .....
WHERE
.....

As you have only provided half of the query, it is hard to do it for you.




Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1407673
Posted Wednesday, January 16, 2013 6:12 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, June 6, 2013 10:53 AM
Points: 36, Visits: 76
thank you so much
Post #1407797
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse