Please help in writing the query to get the output.
Table1:
Fld1 Fld2 Fld3 Fld4
----------------------------------------------
1 1988 5487 2004-08-05 00:00:00.000
1 1988 5675 2006-08-05 00:00:00.000
Table2:
Fld1 Fld2 Fld3
--------------------
2 1988 256
2 1988 250
Output:
Fld1 Fld2 Fld3 Fld4 Fld1 Fld2 Fld3
--------------------------------------------------------------------
1 1988 5487 2004-08-05 00:00:00.000 2 1988 256
1 1988 5675 2006-08-05 00:00:00.000 2 1988 250
Table1:
Fld1 Fld2 Fld3 Fld4
----------------------------------------------
1 1988 5487 2004-08-05 00:00:00.000
1 1988 5675 2006-08-05 00:00:00.000
Table2:
Fld1 Fld2 Fld3
--------------------
2 1988 256
2 1988 250
Output:
Fld1 Fld2 Fld3 Fld4 Fld1 Fld2 Fld3
--------------------------------------------------------------------
1 1988 5487 2004-08-05 00:00:00.000 2 1988 256
1 1988 5675 2006-08-05 00:00:00.000 2 1988 250