hi, i have two table location and marker.when ever data insert into location table means it automatically store marker table also .but i need only four fields from location (i.e)name,street,latitude and longitude.this must store name,address,lat and lng in marker table. how it possible.any body plz help me. thanks
update marker set column1 = (select columntotransfer from location where [condition]) where [condition];