[thelist] SQL query problems...

[Joshua Olson]

> -----Original Message-----
> From: dr Dave
> Sent: Friday, July 16, 2004 3:41 AM
>
> I have a bunch of tables all linked together one-to-many and I want,
> among other things, filter out my results depending on a field in the
> *last* joined table not matching a certain value. So far, easy
> enough... but the catch is: if that value is present for any given row,
> I want to exclude all the rows linked from the same first table's
> index.

Dave,

Sounds like you need to use inner joins instead of left (outer) joins.  With
inner joins, it doesn't matter if the filter is in the WHERE clause or the
ON clause, as the end result is the same.  AND, a filter in any of the
tables will pull out the related fields from the final recordset.

<><><><><><><><><><>
Joshua Olson
Web Application Engineer
WAE Tech Inc.
http://www.waetech.com/service_areas/
706.210.0168