baskaran chellasamy

baskaran chellasamy

  • NA
  • 114
  • 150.6k

how can insert multiple row value to single row value

Sep 3 2012 4:08 AM
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






Answers (1)