how can insert multiple row value to single row value

Question

Hi friends

My first table contain one row
My second table contain three rows

for example
In first table

  1)  10022  kathir   

In second table

1)  2002     morning     
2) 2003      evening
3)2004       day


I want to enter as below in a new table

10022     2002
10022     2003
10022     2004


How can i make query for this result.please help me

Answer 1

Sam,
Thanks for your good help intentions.
I somehow (not sure) managed to restore the files, but I'm not sure what I did.
I simply collected the files I believed should be in the project and made sure they all are in the right folder with the correct namespace, and the most important (i believe) was getting rid of repetitions.
I find the VS (I use Express) to be extremely (dangerously) sensitive to file handling and lacking good automatic file backup (I used to work with Borland Builder where each build saved full backup of previous builds).
I would nevertheless appreciate any good guidelines that will help me prevent such issues in the future.
Sam

Answer 2

Do you still need help?