I'm not sure that my title is descriptive enough, but here is what I need to do...
I had a bit of a screwup today with launching a site...
Within about 10 minutes of opening the site, the members created 337 transactions (stored in trans_table)
Each of those transaction should relate to a position in another table... (position_table)
But for some reason only 245 positions were created.
Now my task is to figure out which transactions in the trans_table don't have a matching record in the position_table
The position_table has a field called mem_id that should match to a field in the trans_table called from_id
And there is also a field in the position_table called pos_trans_id that should match trans_id in the trans_table
I guess what I really need to do is find all of the transactions in the trans_table that don't have a matching record in the position_table and the best match would be the trans_id against the pos_trans_id since there is only a one to one match on that.
I haven't a clue about how to form that query...
Any help that you have would be appreciated.
thanks in advance
Douglas