find request in script not working
I'm relatively new to scripting...
I have three tables - a payment table (with payment id), a disbursement table (with disbursement id), and a table that links payments and disbursements (with payment ids and disbursement ids).
I'd like to find those records in the payment table which do not have an associated disbursement id in the link table. My guess is that I need to copy the disbursement id into the payment table (so it exists in all three tables) -- is that right, or is there an easy way to find records which do not have a related record in another table? Or have I got the wrong idea here?