|
-
Nov 12th, 2009, 12:28 PM
#3
New Member
Re: SQL Join
You will need to restructure your tables a little, like this:
tblComputer
tblComputerID (identity field, Primary Key)
computername
description
tblUser
tblComputerID (Foreign Key, related to tblComputer/tblComputerID)
username
password
The tblUser/tblComputerID points to which computer is associated with which user.
Then your SQL Statements will have to contain a JOIN on the key
Make sense?
Regards,
Will
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|