Hello All
Sorry i might be missing something in below problem I have 2 tables as below
Table 1
ID RID StartM EndM
1 xyz 1100 040.0935 040.1254
2 xyz 1100 029.0110 038.1003
3 xyz 1100 029.0110 038.1010
Table 2
RID StartM EndM XYZ 1100 029.0110 029.0143 XYZ 1100 029.0154 029.0176 XYZ 1100 029.0600 029.0638 XYZ 1100 035.0814 035.0858 XYZ 1100 038.0923 038.1010 XYZ 1100 040.1051 040.1053 XYZ 1100 040.1197 040.1229
Table3
RID StartM EndM ID
Now I need to create 3rd table based on above two tables
for table1.XYZ 1100 table1.StartM>Table2.StartM then table1.ID=2or 3 and
for table1.xyz 1100 table1.EndM< Table2.EndM then table1.ID=1
Regards