Sort out unique user and join tables (1 Viewer)

Sarre

Registered User.
Local time
Today, 21:20
Joined
May 2, 2007
Messages
14
Hi there, hopefully someone knows the answer to this one:

I have a blog with a personal page where users can edit their information.
On this page I need to sort out the unique logged in user in a recordset and at the same time join information from another table.

Have two tables, one for user login info - Users
and one for contactinformation - Contact

Have tried this:

SELECT *
FROM Users, Contact
WHERE Users.ID=Contact.UserID AND Username = MMColParam

Users.ID and Contact.UserID are both PK

No luck, just getting an empty return.

Using Dreamweaver, Access and Asp.
 

Users who are viewing this thread

Top Bottom