Search the Community
Showing results for tags 'left join'.
Found 1 result
I have two files: A parent file and a child file in a one-to-many relationship. Like a Purchase Order that has a header (parent file) and the individual lines of the Purchase Order (child file). I am using a left outer join (all records in Parent file and matching records in Child file), filtered on Parent File ID. I use this because I want to be able to display even those records with no detail so that I can add the details. I pass the Parent File ID in the URL to the Child File and everything comes up the way I expect it to, except the Foreign Key does not get populated with the passed parameter. I am clearly missing something in the process. I am new to Caspio but not new to databases. Can someone point me in the right direction?