Discussion Locked

Crystal Multiple ODBC Data Source Issue

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

How can I link using a Right Outer Join on two tables that use two different ODBC connections?

I'm connected to two different SQL 2000 databases using two seperate ODBC connections and I need to use a Right Outer Join. I can do an Equal Join, but no other Joins choices are available (they are all grey).

Thanks,

Brad

1 reply

by bojidar alexandrov

You can have full join functionality if you write a stored Procedure, or view on one of the SQL Server's that returns needed data from both servers.
Of Course if this is possible in your environment.

This discussion is closed to new replies.