Help with a query

Help with a query

Table1

Name	val2	UIDchild     UIDParent  SequenceID   Action
Bill	B	20				1	Insert
Bill	B2	21	     20			2	Update
Bill	B3	23	     21			3	Update
Tom	G	22				4	Insert
Tom	G2	24	     22			5	Update

I need a query that will give me a Before and After shot of this log table per entry as below.

					            This col not real
Bill	B	20		1	Insert         no before
Bill	B	20		1	Insert         before
Bill	B2	21	20	2	Update         after
Bill	B2	21	20	2	Update        before
Bill	B3	23	21	3	Update        after
Tom	G	22		4	Insert         no before
Tom	G	22		4	Insert          before
Tom	G2	24	22	5	Update           after