Alright, this may be a stupid question, but here goes. I understand joins and have used SQL to do them many times. However, I am seeing weird behavior from Crystal and I want to know if I’m doing something incorrectly.
If I have a Sales Order Table and a Shipping Table and they are linked based up the Sales Order Number, shouldn’t I get all the Sales Order information if I left outer join it to the Shipping Table regardless of whether there are shippers in that table or not?
The behavior I am seeing in Crystal is that the Sales Orders in the Sales Tables which have not shipped yet are not shown on the report at all. I don’t have any selection formula which would make this happen either.
Toad is an application that you can use to run SQL against databases. Other tools include SQL Programmer, DB Artisan etc.
Generally when I have these kinds of problems I’d start by breaking the report down to the smallest pieces where everything works. So just join 2 tables and make sure you are getting what you want. One thing to double check is to make sure that you should be using a left outer join. Try it with a right outer join or even try a full outer to see if you get what you are looking for. Then as you add additional tables and columns when something breaks you will have a better idea what is breaking.
(BOB member since 2007-02-05)
(BOB member since 2005-09-08)