SA 12.1.279 - Odd join suggestions?

SA 12.1.279 - Odd join suggestions?

I've got a PK/FK relationship between two tables using a composited key:

WorkOrderRcptCheckList
WorkOrderRcptChecklistCoolers

if I type inner join WorkOrderRcptChecklist and use the suggested join it's fine.

if I skip using the suggested join and type ON, it gives me the original suggested join AND what appears to be a self join back to itself? On top of that it seems to double up the self join criteria twice over

Video: https://www.screencast.com/t/CaNLQcj0Og

Is the self join second suggestion intentional?

FIXED *edit*

Somehow I had a FK stub on the primary table as well. *facepalm*

I'm not clear. Did you figure it out?

If this is still a mystery? If yes, could please share DDL for both tables so we can see their PK and FK definitions?

	SysOp wrote:
	I'm not clear. Did you figure it out? If this is still a mystery? If yes, could please share DDL for both tables so we can see their PK and FK definitions?

Somehow I had a self referencing FK on my primary table. I have no idea how it got there... I think I'm good.