-
Tricky query.
Hi all,
I need to write a tricky query here:
We have two tables:
DOCDATA (xtopic_id varchar2(255))
and
TOPICS (id,topic).
DOCDATA contains rows with topic id's such as
row1-> 1, 2, 3, 4,5
row2-> 2, 4
row3-> 3, 4
row4-> 3, 5, 4
row5-> 1, 2
TOPICS table has
1, Book1
2, Book2
3, Book3 .....
Now I want to find all the records in DOCDATA, that has a book ('Book3')...or 'Book4' etc.
Any suggestions?
Thanks.
There is always a better way to do the things.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|