Hello. help with request. I need to display a list of mice tied to a PC.
How are you keeping track of the mice? Seems like a custom class, so you'd need to provide more info on that class.
The mouse is in the peripherals. there is also a keyboard, hdd and so on.What information is needed? I'll show everything
Solved the issue with this request:
SELECT Peripheral AS P JOIN lnkPeripheralToPc AS lpc ON lpc.peripheral_id = P.id JOIN PC AS pc ON lpc.pc_id = pc.id WHERE P.devicetype_id = '300'
Log in to post a comment.
Hello. help with request. I need to display a list of mice tied to a PC.
How are you keeping track of the mice? Seems like a custom class, so you'd need to provide more info on that class.
The mouse is in the peripherals. there is also a keyboard, hdd and so on.What information is needed? I'll show everything
Solved the issue with this request:
SELECT Peripheral AS P
JOIN lnkPeripheralToPc AS lpc ON lpc.peripheral_id = P.id
JOIN PC AS pc ON lpc.pc_id = pc.id
WHERE P.devicetype_id = '300'