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 |
|
agravar
Starting Member
1 Post |
 Posted - 2002-04-26 : 20:49:31
|
| This is the problem, the first db i want it to search is in sqlthen the others are in medisoft advantage db. So lets say I search for Jason. I need it to go through the sql dbthen sequentially through the advantage db and return all resultsnot just the results of one table/db. |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-04-26 : 21:26:03
|
| HiYou could set up your advantage db as a linked server (look up books online for how) if you have some drivers for it. Then you could do a UNION inside your query.Damian |
 |
|
|
|
|
|
Combing recordsets