added DISTINCT to the query to get cross reference. This is required when two columns in a table are both foreign keys to another table. From Peter Royal proyal@pace2020.com

Dave Cramer <davec@fastcrypt.com>

Commit: 6a19c6dccfee66df3970dfba15a8590fdd399bc1
Author: Dave Cramer <davec@fastcrypt.com>
Date: 2003-03-25T02:28:45Z
Releases: 7.4.1
added DISTINCT to the query to get cross reference. This is required when two columns in a table are both foreign keys to another table. From Peter Royal proyal@pace2020.com

Files