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 derfloh 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?
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
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
