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 biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Crystal 8.5 and left joins
The error in Crystal is "General SQL Server error: Check messages from the SQL Server". Followed by "Error detected by database DLL" The error in the query tool (which is MS SQL Query Analyzer) is "Server: Msg 4424, Level 16, State 1, Line 1 Joined tables cannot be specified in a query...- Jedak
- Post #4
- Forum: Business Objects: Crystal Reports 2 Data Access
-
Crystal 8.5 and left joins
Sorry, The second SQL statement should be SELECT vw_1.ID, vw_1.DN, vw_1.DR, vw_1.DP, vw_1.DE, vw_1.RDE, vw_1.CA, Table1.NF, Table1.NL, Lookup.LookupValue, Table2.NameFirst, Table2.NameLast FROM DBXX.dbo.vw_1 vw_1 LEFT OUTER JOIN DBXX.dbo.Table1...- Jedak
- Post #2
- Forum: Business Objects: Crystal Reports 2 Data Access
-
Crystal 8.5 and left joins
Hello all, I have a question regarding Crystal 8.5 and left joins. I am using Crystal against a MS SQL 2000 Database using the native MSSQL OLEDB driver (I think, it's under the More Data Source section when setting the Database location). Notes: the dates are parameters When I show the SQL...- Jedak
- Thread
- Replies: 3
- Forum: Business Objects: Crystal Reports 2 Data Access
