By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE `computermapping` (
`ComputerMappingID` int(11) NOT NULL,
`PrinterGUID` char(36) NOT NULL,
`ComputerGUID` char(36) NOT NULL
);
INSERT INTO `computermapping` (`ComputerMappingID`, `PrinterGUID`, `ComputerGUID`) VALUES
(43, 'a353199e-cd02-4fa6-904e-c172235abe9f', '87f44dc7-09e9-483c-935c-325b77ea4355'),
(44, '5549f63f-e02f-4685-a976-96b50c299bed', '87f44dc7-09e9-483c-935c-325b77ea4355'),
(80, 'a353199e-cd02-4fa6-904e-c172235abe9f', '4e392a05-e535-457f-abc3-3f22739aa5ca'),
(90, 'd2e9c5b9-43aa-4713-98e5-deb5e09e461b', '6bc91c0e-9aea-4847-895b-d8064e8feae5'),
(91, '5da046e3-4fb3-4ca5-89e8-239d81d6dc97', '6bc91c0e-9aea-4847-895b-d8064e8feae5'),
(92, '4b4a9288-1368-4ec7-a184-638d432d7d28', '5bec3779-b002-46ba-97c4-19158c13001f'),
(93, '5549f63f-e02f-4685-a976-96b50c299bed', '5bec3779-b002-46ba-97c4-19158c13001f'),
(94, '957b7233-e590-4e7d-aed6-aee0573fc3a8', '5bec3779-b002-46ba-97c4-19158c13001f'),
(95, '5106f1f7-068f-463f-9b76-7cc0ba017184', '5bec3779-b002-46ba-97c4-19158c13001f');
CREATE TABLE `computerdefaultprinter` (
`ComputerGUID` char(36) NOT NULL,
`PrinterGUID` char(36) NOT NULL
);
INSERT INTO `computerdefaultprinter` (`ComputerGUID`, `PrinterGUID`) VALUES
('5bec3779-b002-46ba-97c4-19158c13001f', '4b4a9288-1368-4ec7-a184-638d432d7d28'),
('87f44dc7-09e9-483c-935c-325b77ea4355', 'a353199e-cd02-4fa6-904e-c172235abe9f'),
('6bc91c0e-9aea-4847-895b-d8064e8feae5', 'd2e9c5b9-43aa-4713-98e5-deb5e09e461b');
CREATE TABLE `usermapping` (
`UserMappingID` int(11) NOT NULL,
`PrinterGUID` char(36) NOT NULL,
`UserGUID` char(36) NOT NULL
);
INSERT INTO `usermapping` (`UserMappingID`, `PrinterGUID`, `UserGUID`) VALUES
(63, '4b4a9288-1368-4ec7-a184-638d432d7d28', 'd3cf699b-8d71-4dbc-92f3-402950042054'),
(64, 'a353199e-cd02-4fa6-904e-c172235abe9f', 'd3cf699b-8d71-4dbc-92f3-402950042054'),
select p.PrinterGUID,
(exists (select 1
from computerdefaultprinter cdp
where cdp.PrinterGUID = p.PrinterGUID and
cdp.ComputerGUID = '5bec3779-b002-46ba-97c4-19158c13001f'
)
) as is_computer_default,
(exists (select 1
from userdefaultprinter udp
where udp.PrinterGUID = p.PrinterGUID AND
udp.UserGUID = 'd3cf699b-8d71-4dbc-92f3-402950042054'
)
) as is_user_default
from ((select cm.PrinterGUID
from computermapping cm
where cm.ComputerGUID = '5bec3779-b002-46ba-97c4-19158c13001f'
) union -- to remove duplicates
(select PrinterGUID
from usermapping um
where um.UserGUID = 'd3cf699b-8d71-4dbc-92f3-402950042054'
)
) p
| PrinterGUID | is_computer_default | is_user_default |
|---|---|---|
| 4b4a9288-1368-4ec7-a184-638d432d7d28 | 1 | 1 |
| 5549f63f-e02f-4685-a976-96b50c299bed | 0 | 0 |
| 957b7233-e590-4e7d-aed6-aee0573fc3a8 | 0 | 0 |
| 5106f1f7-068f-463f-9b76-7cc0ba017184 | 0 | 0 |
| a353199e-cd02-4fa6-904e-c172235abe9f | 0 | 0 |