How to use a filter for 2 tables, filter which contains same data, but can;t join table

Hello  I have 2 tables one which contains sales and one with Warranties, i cant use a relation between those 2 table, they are allready joined by the data field, the problem is that both of them con...