Join on Between
I've got an invoice report with data coming from 2 tables dbo.Head and dbo.Positions joined on Head.InvId=Positions.InvId. I now need to add another table dbo.Images that should be joined on Head.Date between Images.DateFrom and Images.DateTo. Problem is that definition of the report is passed through tables and joins made in Links creator, not a command so I can't make such a join in the Links creator. I tried to copy and paste the sql query to command but the report loses fields. Any idea how to cope with it?