Link to home
Create AccountLog in
Avatar of Sam OZ
Sam OZFlag for Australia

asked on

Oracle Join with extra commas

I have  following Tables in Oracle

Table: Books
   BookID
   BookName
   AuthorObjID    



 Table : Author
   AuthorID
   Authorname


  AuthorObjID will follow the format ,AuthorID, (For Example if AuthorID is 1234 AuthorObjID is ,1234,)

 
   How Can I get the List of BookName and corresponding AuthorName ?
ASKER CERTIFIED SOLUTION
Avatar of Ryan Chong
Ryan Chong
Flag of Singapore image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
HI,

Do you have multiple author id in AuthorObjid column like 1,2,34 etc ?

Do you want the query for oracle or SQL ?