Posted by Notgiven on 01/23/06 20:07

I have three tables:

table1:
table2_ID
table3_ID
complete

table3:
table3_ID
name

table2:
table2_ID
table4_ID

Given table3.table3_ID, I need to retrieve the value of table1.complete OR
"Not Complete".

I have tried this in several different iterations without success.

SELECT
IF(ISNULL(e.complete), e.complete,'Not Complete') as complete
FROM table3 s
RIGHT OUTER JOIN table1 e ON e.table3_ID = s.table3_ID
INNER JOIN table2 t ON t.table2_ID = e.table2_ID
WHERE s.table3_ID = 2993
AND t.table4_ID = 10029

Any ideas are much appreciated!

• Next in forum: Re: Acrostix - a PDF library written in PHP
• Prev in forum: Re: question about php script handling/displaying UTF8 email
• Thread view: help with SQL coding question - 3 tables with outer join needed

[Reply to this message]