left join 2 tables multiple times

[knowj]

I am having a bit of a dilemma I have products in a table with multiple categories and need to retrive each relationship as its value (foreigne key as value) this would be simple if it were a single relationship connection but I need to relate the two tables 3 times within a single query which is currently beyond my SQL knowledge. The only other alternative i know would be to run multiple querys but that method seems inefficent.

products

product code, category1, category2, category3
G35E,             1,               2,              3,

categories

id, name
1,  head
2,  feet
3,  hands

How would I go about writing a query that returns the following

product code, category1, category2, category3
G35E,             head,            feet,        hands,

thanks in advance

[leatherback]

Ideally, you'd change your setup:
table1: product_id, product

table2: product_nr, category_nr

table3: category_id category_label

and do a double join product -> link table -> category

which would allow you to expabd to any number of categories you would like and reduce database size in case you do not always have 3 cats defined.