DECLARE @iReturn INTEGER
SET @iReturn=EXEC(P_NextSequenceNo)
Insert Into EmpSequence (InvoiceNo, column1, column2, column3)
select @iReturn , b.value3, 0, a.value1, c.value4
from table1 a,
join table3 b on a.value1=b.value3
and join table2 c on c.value4 = a.value1