SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
SA 12.1.279 - Odd join suggestions?

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
SA 12.1.279 - Odd join suggestions?
Author Message
Mindflux



Joined: 25 May 2013
Posts: 807
Country: United States

Post SA 12.1.279 - Odd join suggestions? Reply with quote
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?
Tue Oct 18, 2022 2:13 pm View user's profile Send private message
Mindflux



Joined: 25 May 2013
Posts: 807
Country: United States

Post Reply with quote
FIXED *edit*

Somehow I had a FK stub on the primary table as well. *facepalm*
Tue Oct 18, 2022 2:46 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7839

Post Reply with quote
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?
Tue Oct 18, 2022 3:04 pm View user's profile Send private message
Mindflux



Joined: 25 May 2013
Posts: 807
Country: United States

Post Reply with quote
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.
Tue Oct 18, 2022 3:05 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.