SELECT help

[Gyurasits Zoltan]

------=_NextPart_000_0019_01C2D79A.9497FFC0
Content-Type: text/plain;
charset="iso-8859-2"
Content-Transfer-Encoding: quoted-printable

HI all!
I want make the SELECT for this situation.....

Example:

Twarehouse
------------------------------
ID name
--- --------
01 Spring_WH
02 Screw_WH
03 Toll_WH
Tparts
--------------------------
ID name
--- --------
01 M3 screw
02 M4 screw
03 Hammer

Tmovement
-------------------------------------------------------------------------=
---------
part_ID incoming_ID outgoing_ID quantity
----------- ----------------- ----------------- =
------------
01 01 02 10
02 01 03 1
03 02 01 5

I want build list about movement, with warehouse's names....

SELECT
twarehouse.name, ?????????? # incoming =
warehouse name
twarehouse.name, ?????????? # outgoing =
warehouse name

tparts.name,
tmovement.quantity
FROM
tparts, twarehouse
INNER JOIN tmovement
ON =20
tmovement.part_ID=3Dtparts.ID=20
-------------------------------------------------------------------------=
---
AND=20
tmovement.incoming_ID=3Dtwarehouse.ID ????????
AND
tmovement.outgoing_ID=3Dtwarehouse.ID ????????
Please help me, who can ..... How can I do??
I don't want make temorary table, if is possible....
Thank You!!!!!

------=_NextPart_000_0019_01C2D79A.9497FFC0--