Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2005
    Posts
    4

    Unanswered: Outer Joins and Substring Error

    My problem exists on the last line - TOAD doesn't seem to like the two sets of parenthesis together. Am I supposed to put something in between? It's OK in the line above because the substring is on the other side.

    SELECT distinct fp.active_fl, fp.empl_id, fp.proj_mgr_name, pm.project, fp.subctr_id, rd.CONT_CRNCY
    FROM planner.rbws_proj_mgr pm, finance.fin_proj fp, finance.rbws_detl rd
    WHERE SUBSTR(fp.proj_id, 1, 9) = pm.project (+)
    AND pm.PROJECT = substr(rd.PROJ_ID,1,9) (+)

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Operative word being "think", I don't think that any version of TOAD can use Oracle outer join syntax in Microsoft SQL Server.

    -PatP

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Oracle 8i or less no doubt

    Code:
    SELECT DISTINCT   fp.active_fl
    		, fp.empl_id
    		, fp.proj_mgr_name
    		, pm.project
    		, fp.subctr_id
    		, rd.CONT_CRNCY 
    	   FROM   planner.rbws_proj_mgr pm
    		, finance.fin_proj fp
    		, finance.rbws_detl rd
    	  WHERE   SUBSTR(fp.proj_id, 1, 9) *= pm.project
    	    AND   pm.PROJECT 		   *= substr(rd.PROJ_ID,1,9)
    Is that the old SQL Server syntax? I thankfully don't remember and have no desire to look it up...speaking of desiree...where is she?

    Where is my Desire?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •