EDITED: Changed "Bikes" for "Computers" (to make it clear that data of different tables cannot be mixed).
Hi, everyone!
Imagine a database with three tables: "Users", "Cars" and "Computers".
Which is the easiest way to get only ONE report that shows each user and which cars and computers has been using (all data at the same time)?
Don't think about ownership of nothing, think more about usage of them.
Example of output:
...User1
..................Car1
..................Computer1
..................Computer2
...User2
..................Car7
..................Car8
...User3
..................Computer8
..................Computer9
...User4
..................Car1
..................Car3
..................Car4
..................Computer8
...
(To understand why this chaos, they gave me two separate Excel tables to work with)
Thanks in advance!
Hi, everyone!
Imagine a database with three tables: "Users", "Cars" and "Computers".
Which is the easiest way to get only ONE report that shows each user and which cars and computers has been using (all data at the same time)?
Don't think about ownership of nothing, think more about usage of them.
Example of output:
...User1
..................Car1
..................Computer1
..................Computer2
...User2
..................Car7
..................Car8
...User3
..................Computer8
..................Computer9
...User4
..................Car1
..................Car3
..................Car4
..................Computer8
...
(To understand why this chaos, they gave me two separate Excel tables to work with)
Thanks in advance!
Last edited: