Join list for tables with multiple joins to same table.

v5.0.96 Pro

Table1
TableOneID
ResidentStateID
TaxStateID

Table2
StateID
Name

Assuming a table that has two or more fields each with a different foreign key to another table (ResidentStateID FK to StateID, TypeTwoFieldID FK to StateIDas a seperate relationship). When presented with a list of possible join clauses, it puts them together in an AND (ResidentStateID= StateID AND TaxStateID= StateID). This is fine if they were in the same relationship. However, if they are in seperate relationships, typically it should show up as two options (ResidentStateID= StateID, next row TaxStateID= StateID).

Hi,

This limitation is by design. You are absolutely correct in terms how it should be working. In the current version, SQL Assistant doesn't distinguish between multiple foreign keys defined between 2 tables. Its internal data cache structures don't support that and don't cache foreign key name or id. I hope we can improve these internal structures in some future version. For additional information, please check SQL Assistant Options -> DB Options -> DB Queries -> Joins (MSSQL)

Thanks