Hi,

I have the following Query:

SELECT AU.ID
, T.SNUMMER
, T.HNUMMER
, AU.ARBEITSSCHEIN_ID
, AU.TEILE_ID
, AU.BAUJAHR
, AU.SEIT
FROM AUSSTATTUNG AU LEFT JOIN TEILE T
ON AU.TEILE_ID = T.ID

now I was wondering if someone can tell me if I am good with a Left join or
better off with an Inner Join. It should give the same result rows since
TEILE_ID <> null.
(This is also linked over Arbeitschein_ID to another Query through
Masterlinks IBO)

TIA.

--
--Chris