String stmt = "SELECT C.number, C.name, C.description, C.weight, P.number, P.name, P.descrption
FROM CAR C, PART P
WHERE C.number = p.car_number"; // (foreign key to CAR table)
I think by using the aliases to tables you can identify what you want.
Please catch up if I could not understand your problem.
Napa