7 Replies Latest reply: Oct 26, 2012 5:22 AM by Joseph Tournas RSS

    Join two tables with a third one, BUT NOT BETWEEN THEM on that field(!!)

    Joseph Tournas

      i understand that my questions sounds weird so let me explain.


      For example, we have a table Payments that includes Date and this Date becomes linked with the Date of my master calendar. Additionally, we have a table invoices that includes Date, but if I keep the same name I get a synthetic table instead because Payments and Invoices are already linked on a supplier ID (!!). So, is there a way to connect Payments Date to Date and invoice Date to Date but NOT Payment Date to Invoice Date on the date field (I still need them to be connected through supplier ID)?? This is only one example, I have many in my script.