Re: SQL help

[Ramalingam Chelliah]

Hi,
Did you try this ?
( Assuming "project" table with columns "projectManager" & "principal"

"user" table with columns "userID" & "username"
and "projectManager" and "userID" columns are similar
)


SELECT user.username,project.principal
FROM project,user
WHERE project.projectManager=user.userID ;

Hope this helps

Regards,
Ram.