InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 18 Jun 2013 01:57:42 GMT20http://www.sqlservercentral.com/Forums/Topic1407296-1063-1.aspxthank you so muchWed, 16 Jan 2013 06:12:12 GMTeboucicauthttp://www.sqlservercentral.com/Forums/Topic1407296-1063-1.aspxCompletly re-write it[code="sql"]SELECT....FROM....INNER JOIN --=.....ON ..... = .....LEFT OUTER JOIN --*=ON ..... = .....RIGHT OUTER JOIN --=*ON ..... = .....WHERE.....[/code]As you have only provided half of the query, it is hard to do it for you.Wed, 16 Jan 2013 01:41:19 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1407296-1063-1.aspxif i got this query how i can replace it by left outer joinSELECT 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 ) andTue, 15 Jan 2013 09:15:23 GMTeboucicauthttp://www.sqlservercentral.com/Forums/Topic1407296-1063-1.aspxFrom 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 80You should be using the full join clauses like INNER JOIN, LEFT OUTER JOIN etc instead.Tue, 15 Jan 2013 08:54:17 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1407296-1063-1.aspxof course i got *= in my query but i use left outer join in the view crv_productosTue, 15 Jan 2013 08:49:41 GMTeboucicauthttp://www.sqlservercentral.com/Forums/Topic1407296-1063-1.aspxDo you have the old style joins in the query or the object crv_productos*= or =*Tue, 15 Jan 2013 08:42:34 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1407296-1063-1.aspxwhen i try to execute a query i got this messageJoined tables cannot be specified in a query containing outer join operators. View or function 'CRV_PRODUCTOS' contains joined tables.someone can help me please.Tue, 15 Jan 2013 08:31:12 GMTeboucicaut