Each regular form have 1 record. All join form joined as outer.
________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Thursday, November 08, 2007 7:10 PM To: arslist@ARSLIST.ORG Subject: [SPAM] Re: Problem with MS SQL Server 2005 Let me guess.. large tables in the join, unindexed join criteria? Resulting in a table scan - it will eventually show the results if you do not press Stop, but your solution is check the join criteria and make sure that the fields in that criteria are indexed from the AR System. A DB level index will not help the AR System to interpret the index. Joe D'Souza -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Beketov Danila Sent: Thursday, November 08, 2007 9:32 AM To: arslist@ARSLIST.ORG Subject: Problem with MS SQL Server 2005 ** I have a serious problem with MS SQL Server 2005. I create some join forms and I get data from last join on MS SQL Server 2000. When I try create the same join forms and retrieve data from its I contemplate this massage "Performing Search". It last until I press button "Stop Search". Anybody confronted with this problem? I attached sample where join "6" do not work on MS SQL Server 2005, but successfully work on MS SQL Server 2000. __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"