Create one record of Multi record

[Mohammad]

Hi

I am very new in SQL and I need you help.I have multi record like :

ID P_CODE
IDNUM1 AA
IDNUM1 BB
IDNUM1 CC
IDNUM1 DD
IDNUM1 YY
IDNUM1 ZZ
IDNUM2 AA
IDNUM2 BB
IDNUM2 CC

Now I have to make new table of those record like this :

IDNUM1 AA BB CC DD (one record FOR ONE ID)
IDNUM1 XX YY ZZ
IDNUM2 AA BB CC

So if the ID has more than 4 of P_CODE I have to generate new record.

Please advise.

Thanks a lot

[Sybrand Bakker]

On 26 Mar 2004 12:49:33 -0800, mhakimjavadi@hotmail.com (Mohammad)
wrote:
HiI am very new in SQL and I need you help.I have multi record like : ID P_CODEIDNUM1 AAIDNUM1 BBIDNUM1 CCIDNUM1 DDIDNUM1 YYIDNUM1 ZZIDNUM2 AAIDNUM2 BBIDNUM2 CCNow I have to make new table of those record like this :IDNUM1 AA BB CC DD (one record FOR ONE ID)IDNUM1 XX YY ZZIDNUM2 AA BB CCSo if the ID has more than 4 of P_CODE I have to generate new record.Please advise.Thanks a lot

I wouldn't switch from a normalized design (scenario 1) to a
non-normalized design (scenario 2) or you must enjoy dealing with
messes.


--
Sybrand Bakker, Senior Oracle DBA