Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Group By Question
Hi, I am running Adaptive Server 11.9 moving towards 12.5. I have 2 queries that should give me the same results but are not! Query 1 gives me multiple rows of repetitive output which I do NOT want. The Query 2 gives me the correct output however it is not written in the standard ANSI way... -
NEED GROUP BY HELP
Hi, I am running Adaptive Server 11.9 moving towards 12.5. I have 2 queries that should give me the same results but are not! Query 1 gives me multiple rows of repetitive output which I do NOT want. The Query 2 gives me the correct output however it is not written in the standard ANSI way...- joined
- Thread
- Replies: 1
- Forum: Sybase: Adaptive (SQL) Server
-
Help With the Groups
Hi all, By now you are all tired of seeing me but maybe some day these problems will help others. The following queries were giveing differnt results and I could not see why. Select A.LoanKeyNum,A.PrinBalAmt, B.NMLLoanInvNum ,LoanMsrDte From elmo..LoanMeasure A, elmo..Loan B Where (... -
MORE HELP WITH JOINS NEEDED
Hi All, I have some more detail on the ealier Outer Join questions. angiole and rudy, both have helped before I hope they can again. Again I am currently using Sybase Adaptive Server Enterprise 11.9 but moving to 12.5. I have two queries that are supposed to display the same results... -
Haing with Outer Joins
HI, I am starting a new thread because I need some help with a query. It is for Sybase Adaptive Server Enterprise version 12.5. The situation is that I am running on 11.9 currently and have to migrate code which is old and not ANSI compliant. Following is an example of code which runs fin... -
Outer Joins and Having
Here are the details. We are running Sybase Adaptive Server Enterprise 11.9. We need to migrate to the new version which is Version 12.5. The new version is more "strict" on using ANSI standards. So we need to make some modifications to our code, especially where we are using some...
