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: 1c4f2a63c0358682f0fd23b9ff61cdf29137cc94
Author: Dave Cramer <davec@fastcrypt.com>
Date: 2003-03-25T02:01:19Z
Releases: 7.3.3
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