SQL for History Records..

Database
Not applicable

SQL for History Records..

Can you please help me out to write the SQL (Select Stmt) to get all the history records from the tables S_Hist and AMS_Hist

Table: S_Hist

S_id Start dt End Dt S_Cd
-------------------------------------------------------------------------
1 1/1/2010 1/15/2010 AB
1 1/16/2010 1/24/2010 CD
1 1/25/2010 12/31/9999 PQ

Table: AMS_Hist

S_Id AM_Id Start Dt End Dt
-------------------------------------------------------------------------
1 123456 1/5/2010 1/27/2010
1 98765 1/28/2010 12/31/9999

Expected Output

S_id start dt End Dt AM_Id S_Cd
--------------------------------------------------------------------------------------
1 1/1/2010 1/4/2010 -- AB
1 1/5/2010 1/15/2010 123456 AB
1 1/16/2010 1/24/2010 123456 CD
1 1/25/2010 1/27/2010 123456 PQ
1 1/28/2010 12/31/9999 98765 PQ

Thanks in Advance..