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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Join/Subquery using values in Select?
Thanks, Crowley16. Is something like the revise below what you have in mind? I'm still struggling with how to use the values in the main select in the subquery for the join? Also, I see I made an error in the datediff above that I corrected below - the difference should be with the date in...- cgeib
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Join/Subquery using values in Select?
Hi All, I am attempting to complete a Stored Procedure to produce reports utilizing Crystal Reports. I am stumbling on a join where I need to base the join on results/values in the select section. I have tried declaring and set/select @variable(s), however, this returns an error that it...- cgeib
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
-
Join two tables on multiple corresponding flds/Null values=lost data
Thank you for your reply! I appologize that I wasn't clear, I'll try to clarify..... "When what field values are null?" When any one of: P_GLDepartment, P_GLFund, P_CAJob, or P_CAActivity, has a Null value. "What isn't being returned?" Any rows from the left hand table nor the joined...- cgeib
- Post #3
- Forum: Business Objects: Crystal Reports 2 Data Access
-
Join two tables on multiple corresponding flds/Null values=lost data
Hi all, New user here struggling with table joining! Novice with SQL and appologize if I've used the wrong terminology. Using: CR XI & SQL Server 2000 Trying to Link two tables in CR on multiple corresponding fields (the combination of all fields creates unique condition for join). When...- cgeib
- Thread
- Replies: 2
- Forum: Business Objects: Crystal Reports 2 Data Access
