Sam OZ
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 ?
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Do you have multiple author id in AuthorObjid column like 1,2,34 etc ?
Do you want the query for oracle or SQL ?