Re: Create Multi record

hi,

For the old table:
IDNUM1 XX YY ZZ (one record FOR ONE IDNUM) IDNUM2 XX YY ZZ
....
IDNUMn XX YY ZZ

suppose the field names for old one are:

KW F1 F2 F3
IDNUM1 XX YY ZZ (one record FOR ONE IDNUM) IDNUM2 XX YY ZZ
....
IDNUMn XX YY ZZ

And the new table has 2 fields: KW and F1, only needs three SQL statements --->

1. Insert into New_Table (KW, F1) (select KW, F1 from Old_Table);
2. Insert into New_Table (KW, F1) (select KW, F2 from Old_Table);
3. Insert into New_Table (KW, F1) (select KW, F3 from Old_Table);

Just try to use insert with sub-SQL.

Johnny Jiang

"Mohammad" <mhakimjavadi_at_hotmail.com>
??????:cc59b627.0403251102.65817289_at_posting.google.com...
> Hi
>
> I am very new in SQL and i need you help.I have record like :
>
> IDNUM1 XX YY ZZ (one record FOR ONE IDNUM)
> IDNUM2 XX YY ZZ
> and I have to make new table of those record like this : (three record
> for one IDNUM)
>
> IDNUM1 XX
> IDNUM1 YY
> IDNUM1 ZZ
> IDNUM2 XX
> IDNUM2 YY
> IDNUM2 ZZ
>
> Please advise.
>
> Thanks a lot
Received on Thu Mar 25 2004 - 17:15:28 CST