You have chosen to sponsor your bid up to a maximum amount of .
You should be good in writing Stored procedures using MySQL or MS SQL SERVER
You should be able to deliver this project within the next few hours.
This is a tiny project - Quick and easy
We have two tables
We need to create a output
The condition is
First match with
Transaction.First name = Parent.First name and Transaction.Last Name = Parent.Last Name and Transaction.Email = Parent.Email.
Second match with those transaction records that does not match the above will then be matched using the following criteria
Transaction.Last Name = Parent.Last Name and Transaction.Email = Parent.Email.
The final output file will have all of the transaction records with only those records that matched with the ID1 and ID2 from Parent.