Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

sql 2000 joins

Status
Not open for further replies.

collierd2

MIS
Feb 26, 2007
61
DE
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

 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top