Hi Mohammed!
Wouldn't it be possible to select the data of the three tables into on table (using UNION for example) and order them correctly.
Afterwards you could select using TOP 800 from this newly created table.
HTH
>hi all,
>
>i need to know how i can append at new table,from table1 as...
>i have 3 area(1,2,3) ,every area have 3 days(1,2,3),
>i need to get randomly 800 records for each day,for every area.
>
>
>
>that mean area1 have 2400 records from 3 days
> area2 have 2400 records from 3 days
> area3..............................
>
>
>thanks.
robert.oh.