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

 Table : Author

  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 ?
Avatar of Ryan Chong
Ryan Chong
Flag of Singapore image

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

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

Do you want the query for oracle or SQL ?