Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2010
    Posts
    49

    Unanswered: Simple?, why doesnt this join work?

    SELECT *
    FROM alltrades as AX , bulkorder as BX
    left join ax on ax.advice = bx.advice

    returns Invalid object name 'ax'

    What am I doing wrong?

  2. #2
    Join Date
    Feb 2004
    Location
    Bangalore, India
    Posts
    250
    try this...

    SELECT *
    FROM alltrades as AX Left Outer Join bulkorder as BX
    on ax.advice = bx.advice
    Cheers....

    baburajv

  3. #3
    Join Date
    Oct 2010
    Posts
    49
    superstar, thank you.

    I've been using oracle too long, forgotton SQL

    Thanks

Posting Permissions

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