The are 2 tables Load and Trload.
Load is the parent table and Trload is the child table.
The common field is load_no.
Everyday Records are inserted from the Load to Trload.Ofcourse TRLOAD has date field .Means for LOAD table unique key is load_no while for TRLOAD date + load_no.
I needed a MySQL query which will insert data from LOAD and in the query there will b a condition for TRLOAD that same load_no for same date is not inserted.