insert Values and selected Items

Can this be done?

I have a procedure where I have Values and Selected Table items that have to be inserted into a nother table that require them to be stored in the same record to the data correctly placed?

This is a simple example.If this is u r requirement its ok. Other than that plz reply to me.

insert into y select * from x

Thank u

Baba

Please remember to click "Mark as Answer" on this post if it helped you.

sql