running crystal 2008
using maximo as my database
my problem is my report I am can get the memo field to show up not issues my problem is when the memo field has no data in it (blank) the line item does not show up.

I cut alot of data out of my report to get rid of possible errors and get to the meet of the report
here is the sql statement. I have tried left outer join but that gives me a failure - when the ld.text is in the report i get only line items that have a ld.text. but I want all items w/ or without ld.text in the long description

any suggestions would be great