1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Error: Ora-00904 - I need help to get this code fix, cheers

Discussion in 'SQL PL/SQL' started by vencoz, Jan 2, 2012.

  1. vencoz

    vencoz Guest

    select bor.borName
    from Borrower bor,Publisher pb
    left join BookTitle bt
    on bt.pubId = pb.pubId
    left join loan lo
    on lo.borId = bor.borId
    and lo.dateOut<>null







    on lo.borId = bor.borId
    *

    ERROR at line 6:
    ORA-00904: "BOR"."BORID": invalid identifier
     
  2. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi,

    Please checkout the data type for that borid column in both(lo,bor) the tables. Might be compatibility problem with those columns. Or check whether both tables having that column.

    Thanks,
    Bharat G.
     
  3. rajavu

    rajavu Forum Guru

    Messages:
    815
    Likes Received:
    52
    Trophy Points:
    610
    Location:
    @ Bangalore , India
  4. kiran.marla

    kiran.marla Forum Genius

    Messages:
    403
    Likes Received:
    52
    Trophy Points:
    505
    Location:
    Khammam
    I did not what this mean
     
  5. rajavu

    rajavu Forum Guru

    Messages:
    815
    Likes Received:
    52
    Trophy Points:
    610
    Location:
    @ Bangalore , India
    Btw,

    should be modified as