LEFT OUTER JOIN PROBLEM--OLEDB-CRYSTAL REPORT

[CherryBlossom]

Hello All,

I have several tables. I'd to link main table and subtables with left outer join, but I've been getting errors. I used OLE DB as my data link. I didn't get any error when I use inner join.

For example, Customer Order table has part no and quantity order. I'd to link with Shipped Order table. I want to see part shipped and part has not shipped; therefore I used left outer join. This should show me all parts that has been shipped as well as part that has not been shipped in the Customer Order Table.

Here are the errors:

Crystal Report: Database Error
No row set returned for this table, query, or procedure.
Error detected by database DLL

Thank you for your feedbacks!

Cherry

 

[rgbean]

Cherry,
How about providing some code that "doesn't" work - may be it's just a matter of adjusting your syntax a bit.

Rick

 

[CherryBlossom]

Rick,

In Crystal Report, it doesn't required to write code to link tables. All we have to do is drag the primary field of main table to foreign key of another table.

With coding, it would look something like this:

CustomerOrder.Part_No--> ShipOrder.Part_No

Cherry

 

[craigber]

What database are you using and what does the query look like?

Craig Berntson
MCSD, Visual FoxPro MVP,

http://www.craigberntson.com

Author, CrysDev: A Developer's Guide to Integrating Crystal Reports"

 

[CherryBlossom]

Craig,

These are DBF Files (Quote It Database). The query would look like this simple PL/SQL statement.

select a.Part_no, a.qty_no
from CustomerOrder a, ShippedOrder b
Where a.part_no=b.part_no(+)

Cherry