How To check whether given date is available in table files for not
select * from om_newarrival where '2012-12-28' between Field1 and Field2
How To Insert data from one table to another table
INSERT store_view (NA_Model,NA_Color,NA_New) SELECT om_newarrival.NA_Model,om_newarrival.NA_Color,'Y' FROM om_newarrival WHERE '2012-12-26' between NA_From_Dt and NA_To_Dt;
How To update table by comparing two tables
update store_view,om_newarrival set NA_New ='Y' where om_newarrival.NA_Model=store_view.NA_Model and om_newarrival.NA_Color=store_view.NA_Color
Comments
Post a Comment