I have 4 Tables:
(((* Means primary key)
1. User (*UserID, FirstName, LastName)
2. Docbase (*Docbase, *UserID)
3. Group (*Group, *UserID)
4. Proj (*Proj, UserID)
a user can belong to none or more then one group, docbase, and project.
I want to create a query that returns all the information about a user including all the docbases, groups and projects that he belongs to.
I have a query that returns the results such as:
UserID Docbase Group Proj
****** ******* ***** ****
User1 doc1 group1 proj1
User1 doc1 group2
User1 doc2 group1
I want a result that would be like:
UserID Docbase Group Proj
****** ******* ***** ****
User1 doc1 group1 proj1
User1 doc2 group2
***docbase, group and proj are not related to each other*******
Can someone please tell me how to write a query that will give me such results
Thank you for your response.
(((* Means primary key)
1. User (*UserID, FirstName, LastName)
2. Docbase (*Docbase, *UserID)
3. Group (*Group, *UserID)
4. Proj (*Proj, UserID)
a user can belong to none or more then one group, docbase, and project.
I want to create a query that returns all the information about a user including all the docbases, groups and projects that he belongs to.
I have a query that returns the results such as:
UserID Docbase Group Proj
****** ******* ***** ****
User1 doc1 group1 proj1
User1 doc1 group2
User1 doc2 group1
I want a result that would be like:
UserID Docbase Group Proj
****** ******* ***** ****
User1 doc1 group1 proj1
User1 doc2 group2
***docbase, group and proj are not related to each other*******
Can someone please tell me how to write a query that will give me such results
Thank you for your response.