you are asking for an "outer join" query.. assuming one table has all of the values, in a two-table join, it's simple.. next to the example element of the link in that table, add the exclamation point.. so try that as a test, first..
if you need to complicate it with more tables for that link and/or no single table has all of the values, there are several ways to approach this.. an example of three-table links:
table A | _link-one !, _link-two ! |
table B | _link-one |
table C | _link-two |
Steven Green - Myrtle Beach, South Carolina USA