is this not a valid FROM statement in sql?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: is this not a valid FROM statement in sql?

  1. #1
    Join Date
    Aug 2001
    Posts
    14
    is this not a valid FROM statement in sql?

    FROM Director, tblMonth LEFT JOIN newQuery ON (tblMonth.Type = newQuery.PromotionType) AND (tblMonth.Month=newQuery.tempMonth) AND (Director LEFT JOIN newQuery ON Director.Code=newQuery.regionalDirectorCode)

    i get an error on:

    (tblMonth.Month=newQuery.tempMonth)

    about it having invalid syntax but it worked before when i used everything but the last AND condition.
    thanks!

    arage

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    i have never used LEFT JOIN syntax in Oracle, actually I didnt know it works!

  3. #3
    Join Date
    Aug 2001
    Location
    Manchester, UK
    Posts
    86

    is this not a valid FROM statement in sql?

    R u talking about sql in Oracle .

    Seen these kind if codes in VB. Never seen LEFT JOIN in Oracle.


    OCP IP.


    -- Anurag.
    OCP Application Developer
    ---------------------------------------------------------
    "Be not afraid of growing slowly. Be afraid only of standing still."

  4. #4
    Join Date
    Oct 2000
    Location
    Germany
    Posts
    1,185
    What should left join accomplish?

    Thanks in advance.
    David Knight
    OCP DBA 8i, 9i, 10g

  5. #5
    Join Date
    Mar 2001
    Location
    Reading, U.K
    Posts
    598
    HI u cannot use these type of jin in Oracle
    these types of joins r in MS SQL SERVER & SQL ANYWHERE
    Cheers!
    OraKid.

Posting Permissions

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


Click Here to Expand Forum to Full Width