Append multiple records from a single record

[Guest]

I have a table "Items" of orders for items such as gift certificates. I
transfer the gift certificate orders to another table "GC" which becomes the
log of gift certificate numbers and the unused balance of the certificate.
My problem is sometimes a customer orders two or more gift certificates and
I must manually duplicate that order in the "GC" table as many times as
needed so I can assign the correct gift certificate number to each
certificate and track the balance of each certificate.
Is there some way I can programatically do this?

 

[dbahooker]

I have a table "Items" of orders for items such as gift certificates. I
transfer the gift certificate orders to another table "GC" which becomes the
log of gift certificate numbers and the unused balance of the certificate.
My problem is sometimes a customer orders two or more gift certificates and
I must manually duplicate that order in the "GC" table as many times as
needed so I can assign the correct gift certificate number to each
certificate and track the balance of each certificate.
Is there some way I can programatically do this?

yeah a UNION statement..

-Aaron

 

[Guest]

I don't understand how a union statement would append two or more new records
to "GC" based upon one record in "Items"... Can you explain?