Create Multi record
From: Mohammad <mhakimjavadi_at_hotmail.com>
Date: 25 Mar 2004 11:02:50 -0800
Message-ID: <cc59b627.0403251102.65817289_at_posting.google.com>
Date: 25 Mar 2004 11:02:50 -0800
Message-ID: <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
IDNUM1 XX
and I have to make new table of those record like this : (three record
for one IDNUM)
IDNUM1 YY
IDNUM1 ZZ
IDNUM2 XX
IDNUM2 YY
IDNUM2 ZZ
Please advise.
Thanks a lot Received on Thu Mar 25 2004 - 20:02:50 CET