Home » Developer & Programmer » Reports & Discoverer » Excluding SQL query data when linked with XML query (Report Builder, 10g, win7)
icon5.gif   Excluding SQL query data when linked with XML query [message #583186] Fri, 26 April 2013 09:39 Go to next message
whoswho
Messages: 2
Registered: April 2013
Junior Member
Hello everybody,

I have data in a table and another in XML file,
I used SQL query to retrive the data placed on the table, and link this query with XML query that retrieves the data stored in the xml file.
The data stored in the table and xml file sharing a key field, but the xml contents are less than what in the table.
I want to show only the data shared between the two queries, how can I do that?

e.g.:
Table emp:
e_id | e_name | e_sal
023 | John | 6000
143 | Tom | 9000
876 | Chi | 4000
987 | Alen | 7800


XML File
<e_id>
143
876


So, I want the output to be:
e_id | e_name | e_sal | e_fee
143 | Tom | 9000 | 300
876 | Chi | 4000 | 100

Can you help me??

Thank you
Re: Excluding SQL query data when linked with XML query [message #583188 is a reply to message #583186] Fri, 26 April 2013 09:49 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use a join?

And where do come 300 and 100?

Regards
Michel

[Updated on: Fri, 26 April 2013 09:49]

Report message to a moderator

Re: Excluding SQL query data when linked with XML query [message #583192 is a reply to message #583188] Fri, 26 April 2013 12:38 Go to previous message
whoswho
Messages: 2
Registered: April 2013
Junior Member
I want to use right outer join, but how to do that???
I built the report as in oracle documentation:
Oracle Reports Building Reports
Subject: Building a Report with an XML Pluggable Data Source


and the link between XML & SQL queries seems to be left outer join, but I want it to be right outer join.

forget the data 300 and 100. They are examples for calculating fees.

Regards
Previous Topic: Rupee Image extension in salary
Next Topic: print images on report based on data
Goto Forum:
  


Current Time: Thu Mar 28 06:47:16 CDT 2024