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 |
|
ntn104
Posting Yak Master
175 Posts |
 Posted - 2008-04-30 : 21:25:11
|
| The original post has been move to different forum...Thanks, |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-01 : 00:04:27
|
| Can you specify what your requirement is? May be give some sample data to illustrate it. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-01 : 07:47:19
|
| What does each dba table indicate? |
|
|
|
cat_jesus
Aged Yak Warrior
547 Posts |
Posted - 2008-05-01 : 10:20:24
|
| I don't understand. Are you using linked access and linked mainframe tables in SQL server? Or have you already imported the data into SQL server?An infinite universe is the ultimate cartesian product. |
|
|
|
cat_jesus
Aged Yak Warrior
547 Posts |
Posted - 2008-05-01 : 10:53:41
|
| OK This is a SQL server forum, not an ACCESS forum.Also keep in mind that if you are joining linked tables from different databases in a query, the database engine is going to return ALL ROWS from the lnked table before it does the join. This could cause major problems.Without seeing what you're doing, I'd suggest importing the access data into the mainframe and then doing your query there.An infinite universe is the ultimate cartesian product. |
|
|
|
ntn104
Posting Yak Master
175 Posts |
Posted - 2008-05-03 : 10:17:50
|
| Thank for Information. I got it work...I am gonna move these postings to Access forum... |
|
|
|
|
|
|
Multiple join tables-move to different forum