Join Bug
unionguy
Posts: 13
Hi I found a small bug with the Join options that are provided.
If I have the following SQL and the Job table has a foreign Key to both Job_Chapter and Job_Employer the suggested candidates that are shown is only the foreign key for the Job_Chapter. In fact in playing around with it some more it seems that only the foreign keys for the table that is right above what you can currently joining are the only keys that are checked. Is this the way it show work? For me a lot of the time I join more than once to the same table and it's a bit of a pain to have to insert my joins right below the the table I need to join to each time.
SELECT *
FROM dbo.Dues D
INNER JOIN dbo.Job_Employer je ON D.EmployerID = je.EmployerID
INNER JOIN dbo.Job_Chapter jc ON D.ChapterID = jc.ChapterID
INNER JOIN dbo.Job J ON
I not sure if you have covered this already, but thanks for looking into it.
If I have the following SQL and the Job table has a foreign Key to both Job_Chapter and Job_Employer the suggested candidates that are shown is only the foreign key for the Job_Chapter. In fact in playing around with it some more it seems that only the foreign keys for the table that is right above what you can currently joining are the only keys that are checked. Is this the way it show work? For me a lot of the time I join more than once to the same table and it's a bit of a pain to have to insert my joins right below the the table I need to join to each time.
SELECT *
FROM dbo.Dues D
INNER JOIN dbo.Job_Employer je ON D.EmployerID = je.EmployerID
INNER JOIN dbo.Job_Chapter jc ON D.ChapterID = jc.ChapterID
INNER JOIN dbo.Job J ON
I not sure if you have covered this already, but thanks for looking into it.
