SQL select statement from 2 tables
- by Steven
Hi, I have a small sql question.
I have 2 tables
Members and Managers
Members has: memberID, Name, Address
Managers has: memberID, EditRights, DeleteRights
EditRights and DeleteRights are of type bit.
Mangers have a relationship with Members, because they are members themselves.
I want to select all members id's, name and adress and for the…