Need sql query to get the output from two table
727350Jul 13 2010 — edited Jul 13 2010Hi all,
I think i need to precise my doubt in more easy way since i didnt get any responce of my last post.
anyway with few sample data and small scenario i hope i may get some help from u all guys.
here is table description.
sql> select * from req;
requestid topicdesc subtopicdesc
---------- ----------- ---------------
1111 topic subtopic3
sql> select * from req_hist;
requestid topicdesc subtopicdesc
---------- ---------- ---------------
1111 topic subtopic1
1111 topic subtopic2
i want the output like this ????
requestid topicdesc subtopicdesc
---------- ----------- ---------------
1111 topic subtopic1
1111 topic subtopic2
1111 topic subtopic3
i am unable to create a query which gives this desired result.
Can anybody help me out.
Thanks n regards
Laxman