Hi I am sitting on it from the past one day but could not come up with the right solution, I am a newbie to sql .. Please Help me in understanding thisTable PartPARTNUM SUPPLIERNUM PARTTYPE COST APPLIANCENUM191 2045 Handles 9 12497191 3728 Motors 62 23479191 2457 Motors 45 32487192 4568 Accessories 20 13789192 1234 Motors 140 38979193 4345 Motors 90 23479193 1784 Accessories 8 38979
To get a grip on the problem, they would like to first identify all part numbers that map to different part types . Write a query that lists part numbers that can have different part types. Order the result by partnum.Desired Out PutPARTNUM firstType secondType191 Motors Handles192 Motors Accessories193 Motors Accessories202 Motors Accessories292 Pumps Motors293 Pumps Motors392 Pumps Motors
My Analysis and codeselect distinct p1.partnum,p1.parttype FirstType,p2.parttype Secondtype from part p1,part p2 where p1.parttype != p2.parttype and p1.partnum = p2.partnum order by p1.partnum
PARTNUM FirstType Secondtype 191 Handles Motors 191 Motors Handles 192 Accessories Motors 192 Motors Accessories 193 Accessories Motors 193 Motors Accessories 202 Accessories Motors 202 Motors Accessories 292 Motors Pumps 292 Pumps Motors 293 Motors Pumps 293 Pumps Motors 392 Motors Pumps 392 Pumps Motors