Good evening
I'm completing a database to record who has been assigned hardware
So I have 2 list:
list hardware:
with element: id, type (pc, printer, monitor), model, serial number, iduser
list user:
with element: iduser, first name, last name
I didn't understand how to do joins
I did a left join with hardware.iduser and user.iduser
But in fact the relationship should be many to many
because a user can have a lot of hardware and hardware can have more users over time
How can I make this join?
I'm completing a database to record who has been assigned hardware
So I have 2 list:
list hardware:
with element: id, type (pc, printer, monitor), model, serial number, iduser
list user:
with element: iduser, first name, last name
I didn't understand how to do joins
I did a left join with hardware.iduser and user.iduser
But in fact the relationship should be many to many
because a user can have a lot of hardware and hardware can have more users over time
How can I make this join?