Use an appropriate status. Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com Dee Ayy wrote: > On Fri, Aug 8, 2008 at 5:25 PM, Micah Gersten <micah@xxxxxxxxxxx> wrote: > >> How about "select Incidents.* from Incidents inner join Calls on >> Incidents.id=Calls.incidentid where Calls.status='Open'"? >> > ... > >> Dee Ayy wrote: >> > ... > >>> The status column never has the text "Open". >>> > ... > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php