Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Record selection as tables joining

Hi All,

I've got 2 tables: Invoices and Images like below. Due to the nature of the report (discussed here) they must be joined within record selection section, not in sql command nor in links, and the joining (or selection in this case) should look like {Invoice.Date}>={Images.DateFrom} and {Invoice.Date}<={Images.DateTo}.


Images table includes records that should appear only on some of the invoices i.e. some invoices will have an image some will not. Joining/selection like the above excludes Invoice.Id=3 because its data does not fall into any images date range. Question is - how can I do the record selection so that all invoices are included even these that have no image?

Invoices

IdDate
12015-01-06
22015-01-16
32015-01-26

Images

IdDateFromDateTo
12015-01-022015-01-18
22015-01-302015-01-31

Regards,

przemek

Former Member
Former Member replied

Hi Nrupal, unfortunatelly, it didn't work. I've managed to do that vie SQL field, though. Thank you, anyway.

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question