SoftTree Technologies Technical Support Forums Register • Search • FAQ • Memberlist • Usergroups • Log in Join Suggestions      SoftTree Technologies Forum Index » SQL Assistant View previous topic View next topic Join Suggestions Author Message judahr Joined: 09 Mar 2007 Posts: 319 Country: United States Join Suggestions 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 SysOp Site Admin Joined: 26 Nov 2006 Posts: 7948 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 judahr Joined: 09 Mar 2007 Posts: 319 Country: United States 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 judahr Joined: 09 Mar 2007 Posts: 319 Country: United States Just noticed that the left outer join is on a view. If that makes a difference. Tue Jan 29, 2008 4:11 pm SysOp Site Admin Joined: 26 Nov 2006 Posts: 7948 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 judahr Joined: 09 Mar 2007 Posts: 319 Country: United States 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 SysOp Site Admin Joined: 26 Nov 2006 Posts: 7948 Can you post a screenshot with the SQL and popup visible? Tue Jan 29, 2008 4:38 pm judahr Joined: 09 Mar 2007 Posts: 319 Country: United States It contains identifying information, so I sent via email. Tue Jan 29, 2008 4:41 pm Display posts from previous:  All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year  Oldest FirstNewest First     SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours Page 1 of 1   Jump to:  Select a forum ----------------SQL AssistantDB Audit, DB Mail, DB Tools24x7 Scheduler, Event Server, Automation SuiteTips & Snippets Repository 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.