I have a table named
Cars and a function named
there is no direct link between
partid. the link is though 3 tables in the middle. I do have a function called
PartsPerCar which gets
carid (it goves via the tables in the middle) and give back all the
partid related to
for example : if I choose
carid=125 I can call
PartsPerCar(125) and get:
part id part name 10 Wheel A 12 Wheel D 13 Glass F
what I want to get eventualy is to get a list of all cars and all it's parts.
Car ID , Part ID , Part Name 1 15 engine A 1 17 engine C . . . 125 10 Wheel A 125 12 Wheel D 125 13 Glass F
the thing is that there is nothing to do join on.
I know I can do:
select PartsPerCar(carid) from Cars
but it doesn't help me so much as I need the
partid to use with the WHERE statement. In this way I can't do that.