sql2005

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services 2005 Development » sql2005

sql2005

Rate Topic

Display Mode

Topic Options

Author

Message

eboucicaut

Posted Tuesday, January 15, 2013 8:31 AM

SSC Rookie

Group: General Forum Members
Last Login: Friday, May 17, 2013 10:08 AM
Points: 36, Visits: 74

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

anthony.green

Posted Tuesday, January 15, 2013 8:42 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

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

eboucicaut

Posted Tuesday, January 15, 2013 8:49 AM

SSC Rookie

Group: General Forum Members
Last Login: Friday, May 17, 2013 10:08 AM
Points: 36, Visits: 74

of course i got *= in my query but i use left outer join in the view crv_productos

Post #1407307

anthony.green

Posted Tuesday, January 15, 2013 8:54 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

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.

Post #1407310

eboucicaut

Posted Tuesday, January 15, 2013 9:15 AM

SSC Rookie

Group: General Forum Members
Last Login: Friday, May 17, 2013 10:08 AM
Points: 36, Visits: 74

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

anthony.green

Posted Wednesday, January 16, 2013 1:41 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

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.

Post #1407673

eboucicaut

Posted Wednesday, January 16, 2013 6:12 AM

SSC Rookie

Group: General Forum Members
Last Login: Friday, May 17, 2013 10:08 AM
Points: 36, Visits: 74

thank you so much

Post #1407797

« Prev Topic | Next Topic »

Permissions