RE: OUTER join problem

See below. -----Original Message----- From: Dusan Mijavec [mailto:dmijavec@bradson.com] Sent: Friday, May 05, 2000 11:37 AM Posted To: informix Conversation: OUTER join problem Subject: Re: OUTER join problem OK here is select statement SELECT applicant.applicantid, applicant.lastname, applicant.firstname, [many lines of select clipped] assignment.applicantid = payroll.applicantid AND[several more lines clipped] what I found is that if I delete from payroll it is working fine, but that is confusing becouse I have no rows in payroll for this order_id I don't suppose those rows you deleted from payroll had null in key fields (i.e. payroll.applicantid ) did they? Or on a second level, did they join to records whose fields joined to another table, any of which had null data. When you get rows that you don't intend this is often the problem. Just something you might want to check out. Art S. Kagel wrote in message <3911E45C.272868D@bloomberg.net>... >Dusan wrote: >> >> HI >> I have select statement with 7 outer joins, like result i am receiving 5 rows, >> should be only one. What is good strategy / tools to find out why >> Dusan > >Large economy sized bottle of ibuprofen! Build the query one table at a >time and see when the results go out of expectations. You might also post >it here and perhaps someone will spot something. > >Art S. Kagel