SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Join Suggestions

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
Join Suggestions
Author Message
judahr



Joined: 09 Mar 2007
Posts: 314
Country: United States

Post Join Suggestions Reply with quote
v. 3.1.10

Love the new feature. It's not using the alias and its not generating good syntax.

Select
From Database1.dbo.Table h
LEFT OUTER JOIN Database1.dbo.Table2 h2
On

suggests
Database1.dbo.Column1 = h.Column1

should suggest:

h.Column1 = h2.Column1 (thats the order of the From clause)
or
h2.Column1 = h1.Column1
Tue Jan 29, 2008 1:07 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6500

Post Reply with quote
I'm unable to reproduce this issue so far. For me, it always displays joins in the proper order, alias of the joined table (second table) on the left hand side, primary table alias on the right side., for both foreign keys and column name matches.

We are going to have a new private build ready today or tomorrow. Can I send it to you for rechecking this issue?
Tue Jan 29, 2008 3:50 pm View user's profile Send private message
judahr



Joined: 09 Mar 2007
Posts: 314
Country: United States

Post Reply with quote
I'll be out of town for two weeks starting tomorrow. You could send a build around that time.
Tue Jan 29, 2008 4:08 pm View user's profile Send private message
judahr



Joined: 09 Mar 2007
Posts: 314
Country: United States

Post Reply with quote
Just noticed that the left outer join is on a view. If that makes a difference.
Tue Jan 29, 2008 4:11 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6500

Post Reply with quote
Still works for me. Of course, I get column name matches only, but still in the correct order.
Tue Jan 29, 2008 4:17 pm View user's profile Send private message
judahr



Joined: 09 Mar 2007
Posts: 314
Country: United States

Post Reply with quote
When I choose the option, I still get Database1.dbo.Column1 = h.Column1

I can send you a file or query, if you let me know < 4 EST.
Tue Jan 29, 2008 4:27 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6500

Post Reply with quote
Can you post a screenshot with the SQL and popup visible?
Tue Jan 29, 2008 4:38 pm View user's profile Send private message
judahr



Joined: 09 Mar 2007
Posts: 314
Country: United States

Post Reply with quote
It contains identifying information, so I sent via email.
Tue Jan 29, 2008 4:41 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.