SQL for History Records..

Database
N/A

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..