Sql

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