assign seuqnce numbers

[chamilz]

I have a Product_Table like below and need to assign Sequence(SEQ) numbers from a seperate_Table for each product group i.e. unique number for product/supp/color/size/qty.

My sequence_table has sequence_id, Sequence_number.

Product supp color size Qty SEQ
430500001 15351 200 900 1 1
430500001 15351 200 910 2 1
430500001 15351 101 900 1 2
430500001 15351 101 910 2 2
430500001 15351 208 900 1 3
430500001 15351 208 920 2 3
430500002 15351 200 920 1 4
430500002 15351 200 930 2 4
430500002 15351 101 920 1 5
430500002 15351 101 930 2 5
430500002 15351 208 940 1 5
430500002 15351 208 950 2 5
430500002 15351 215 910 1 7
430500002 15351 215 920 2 7
430500003 15351 903 950 3 8
430500003 15351 903 960 6 8
430500003 15351 903 970 2 8

You assistance really appriciate.
Thanks

 

[amrita418]

What other columns does that table have? anything to join on?

Regards,
AA

 

[chamilz]

No. there is no other table to join.
Product_table is sorted based on the Product_code

Squence Table carry all the sequence numbers that have been already assigned to Product Table.

Each time, next available sequence number from Seuqeunce Table will be assigned to product_table base on the product/supp/color.

Thanks,