usertype means to check if the type of user is a staff or an account(registered customer)
is not one or more accounts and one or more staff account
both are one-to-one relationships.
So is it possible to make a select statement joining all together?
I am trying to see which type of account is it when i sign in to the website
FROM User AS u
JOIN Account AS a
ON a.userId = u.userId
JOIN Staff AS s
ON s.userId = u.userId
COOL! IT WORKS! THANK YOU SO MUCH!!! It was just an example but it totally rock-ed!!
Sorry but I got a few more questions.. :X
May I know what is left outer join? How to use it?
And what is the difference between
"Account a" and "Account As a"?