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.

Thx in advance....

See the MySQL documentation for how to handle a PRIMARY KEY.

-PatP

Im new to My-SQL .Plz elaborate how this will help me...