hi,
thank you for reply,

i don't say 3 tables ,i have one table have all records(area,days)

choice 800 randomly from avery day for avery area,insert to new table

thanks