In response to Greenhorn :
> >
> > Use a left join instead?
> Hi,
> Yes, but when i use a where clause on my query it only selects joined
> records. :(
> Thanks.
Please, answer to the list and not directly to me.
The WHERE-Clause works after the JOIN - so your select contains (without
the WHERE) all rows.
Maybe i don't understand you, can you show a simple example with data?
Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)