Re: request for help with multiple JOINs

2002-02-14 Thread DL Neil
Andreas, If anyone else is interested, I have solved the problem in stepwise/tutorial fashion below (best viewed using a fixed font). If anyone is skilled in the user of FROM...JOINs, (I'm sure Andreas, and) I'd welcome a critique/any improvements! I have taken a look at this problem, and bein

request for help with multiple JOINs

2002-02-13 Thread Andreas Habereder
Is there anyone who could help me with this "simple" query. Did i ask anything in a wrong way because I still got no answers to my request? SELECT at.name, av.value, at.unit, at.id, a.product_id FROM attribute_type at LEFT OUTER JOIN attribute a on (at.id = a.type_id) LEFT OUTER JOIN attrib