I have a requirement where say I have File1 and File 2 have to be queried in such a way that when I select a record from File1, the next record should be from File 2, the third one from File1 and 4th from File2, in a single output query
Ex:
File1 Data

Fld1 Fld2
001 India
002 China

File2 Data

Fld1 Fld2
28 ABC
30 DEF

Output requriement is of the below type, using a single query. Alternate ideas will be highly appreciated.

Fld1 Fld2
001 India
28 ABC
002 China
30 DEC