Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Need to select first record only from a left outer join
Hi I'm using CR 8.5 SP1, the data is held on Oracle 8i but is accessable only via a Baan IV driver. The Baan IVc4 system has multiple contract lines since each Part may have several delivery addresses hence potentially several records on the Sales Contract table. I think it may be worth my...- nbrown
- Post #3
- Forum: Business Objects: Crystal Reports 2 Data Access
-
Need to select first record only from a left outer join
I have four tables the first is "Inventory Transactions" this is linked to three other tables via a left outer join. I need the selling price held on the table "Sales Contract" in order to calculate the Sales value of the inventory transaction. The only common data is the...- nbrown
- Thread
- Replies: 2
- Forum: Business Objects: Crystal Reports 2 Data Access
