Re: [PHP-DB] Cross reference query help

2010-02-07 Thread Chris
Ron Piggott wrote: The following is a query I am working on today. I need help tweaking on it. What I am trying to get for results from the query are where there are rows in either table, not all 3 tables linked together. In other words I am trying to INNER JOIN these two pairs of tables for

[PHP-DB] Cross reference query help

2010-02-06 Thread Ron Piggott
The following is a query I am working on today. I need help tweaking on it. What I am trying to get for results from the query are where there are rows in either table, not all 3 tables linked together. In other words I am trying to INNER JOIN these two pairs of tables for possible results: