SQL JOIN help

[Sean Wilson]

>SELECT *
>FROM
>     tblCustomers, tblLocations, tblTasks,
>WHERE
>  tblTasks.taskLocID = tblLocations.locID
>  AND tblLocations.locCustId = tblCustomers.custID
>  AND IsNull(tblTasks.taskCompleteDate)
>
>  AND  tblTasks.taskTypeName IN ( select taskTypeName from taskTypes
>  where ......)

Excellent. Thanks Ivan.