Re: Problems with an outer join. It joins a second table even it should not, there is no records in a second for specified criteria.

rfurdzik@paulweiss.com wrote: > > When you do an outer join with another table to which you applied criteria > which in result returns no data, an outer join still will be performed joining > a row from first table with an empty row. Please help That's the *definition* of an outer join. You need an inner join. In Informix, omit the word "outer". <code snipped> -- Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 --- If all else fails, read the instructions and the release notes. Join Infuse, the UK Informix User Group at http://www.infuse.org.uk/ ---