Order from another Database

[DanBates]

Ok here's what I've got.....

---

Database_1, Table_Users:
user_id, user_name, user_password.

Database_2, Table_downloads:
download_id, download_name, download_userid, download_url

---

In 'Database_2' the column 'download_userid' is a reference to 'user_id' in 'Database_1'. Now, I want to order a query on 'Database_2' by the 'user_name' column in 'Database_1'. This is so the users can list downloads by a 'user name' field on a webpage.

Any ideas?

[drawmack]

why are you using seperate databases? If you have foreign keys that go between databases they should probably be seperate tables within the same database.

[DanBates]

Database_1 is a database used with a forum nad this is where the users infomation is kept. Database_2 is used for items such as downloads on the main part of the site.

[mourisj]

I really on't see any reason to have different databases for that.

You just need an adequate design of the structure of one single database !!

JJ Mouris