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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Help with a Join
I have a decode statement that makes the table's columns have matching values. The problem is, I have 2 queries that run in about 30 seconds each. However, when I join the tables and create a single SQL statement the query takes over 10 minutes before I cancel it! Could a non- primary key /... -
Help with a Join
I have 2 Oracle 8i tables with about 15 columns each. I want to join these tables, but there is no relationship. Can I just join the tables on like columns?
