sql 2000 joins

[collierd2]

Hello

I'm wondering if anybody has any recommendations for this issue:

If I run a simple select, it works

If I join to another table, it works
If I join to a seperate table, it works

Now if I join to both tables, it runs indefinitely

Does anybody have any suggestions


Thanks

 

[r937]

my first suggestion would be to tell us what your queries look like, then tell us what your tables look like, and specifically which columns have indexes

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon