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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
sp_addlinkedserver from MS SQL 2000 to Sybase
I am running into an issue trying to link from MS SQL 2000 to Sybase. I run the sp_addlinkedserver, which appears to work successfully: exec sp_addlinkedserver @server='test', @srvproduct = '', @provider = 'msdasql', @datasrc = 'Data Source=mySrc;UserID=usrID;Password=pwd', @location =...- AceFM
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
-
Inaccurate results from Outer Join query on linked tables
I have run into a very strange problem. Running MS Access 2003, SP3. I am running a simple query with 2 tables, using an outer join, looking for a list of all records in table 1 where there is no corresponding entry in table 2: SELECT Table1.key, Table1.lastname, Table1.firstname FROM...- AceFM
- Thread
- Replies: 16
- Forum: Microsoft: Access Queries and JET SQL
