Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-09-11 : 14:00:04
|
| Ritu writes "How do I compare the data of 2 tables having same table structure but in two different databases. I am using sybase10.2" |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2002-09-11 : 14:34:30
|
| you need to look into the following concepts / structures...1. multi-part table naming convention/structure.2. inner join, left join, right join....one will give you records in A and B, one records in A not in B, one will give you records in B not in A...search here for examples of same....this particular problem has come up here before....and the solutions (other than the red-gate.com one which is a product aimed solely at SQLServer) may be customisable/translatable to Sybase. |
 |
|
|
|
|
|
data comparison in sybase