Simple INNER JOIN candidates bereft of FK

PDinCA · October 9, 2009 1:10PM

Code is simple:

SELECT *
  FROM dbo.IndividualOrganization io
       INNER JOIN dbo.Individual ind
               ON ind.IndividualID = io.IndividualID
              AND ind.IsActive     = 1
       INNER JOIN dbo.Organization org
               ON

I expect the candidate list to show me declared FK's but in this case, all I get are the column name matches between ind and org - the FK from Organization to IndividualOrganization (an intersecting Entity that carries additional data) is entirely missing... Should be

ON org.OrganizationID = io.OrganizationID

Strangely, after I manually code the above join then code another JOIN to the same IndividualOrganization table, the candidate list gives me the FK

INNER JOIN dbo.Position psn
               ON io.PositionID = psn.PositionID

I searched this Forum for "Foreign Key" but none of the posts showed the same issue.

This happens FREQUENTLY when an intersecting entity is feature first.

Version: 4.0.2.57
(Table and all relationships have been around for all the time SQL Prompt has existed and the cache is refreshed.)

Anu D · October 12, 2009 5:55AM

Many thanks for the post.

Can you kindly confirm that following option is checked:

SQL Prompt 4 --> Options --> Suggestions --> Join Conditions --> Individual coulmns in multiple-column foreign keys ?

PDinCA · October 12, 2009 12:27PM

Confirm that option is checked. Columns with matching names is checked. Columns with matching data types is not.

Anu D · October 13, 2009 10:16AM

Thanks for the update.

I have dropped you an email can you kindly let us know your views on that.

PDinCA · October 13, 2009 12:15PM

SQL Compare scripted DB emailed... Thanks.

Simple INNER JOIN candidates bereft of FK

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk