The sequence number IS coming from TableA.

Part of the problem, is that you haven't been able to give a clear picture of what you want, because you're talking in generalities instead of posting something concrete like sample data and expected results. You can find out how to do this by reading the first link in my signature.

Drew