I have a table named Cars
and a function named PartsPerCar
there is no direct link between carid
and 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 carid
.
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.
something like:
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.