SQL inner join statement

[Stelly]

Hey All,

Have this statement but can't find for the life of my whats wrong with it!

SELECT Users.UserName, OldComp.DateStamp
FROM Users, OldComp
WHERE OldComp.CompID = @PCID

Stelly

 

[Stelly]

It is solved after having a brew and chilling... missed this...

SELECT Users.UserName, OldComp.DateStamp
FROM Users, OldComp
WHERE OldComp.CompID = @PCID
AND OldComp.UserID = Users.UserID

 

[MagicalTrevor]

You've got no way of joining the two tables together

EDIT: Looks like you've solved it