I've never been much of a SQL query whiz and I am trying to build a query within Crystal reports (XI) with quite a few tables linked together.
The problem I run into is:
Crystal is not showing an entire row of data if one of the tables happens to be null in value. So I'm coming short in what I should be reporting.
Crystal reports doesn't seem to allow a "LEFT" join for linking of tables, (which would resolve my issue) and I'm not quite sure how to get around this.
Any crystal guru's out there that may know the answer?
Something tells me you should try an Outer join.
Might be the mous in my pocket. ;-)
If you're a slave to your free associations, does it automatically become something else?