l—ÍŒŸõ‚Í‚Ä‚È
ÓÊ޲ٔłð•\Ž¦‚µ‚Ä‚¢‚Ü‚·¡PC”Å‚Í‚±‚¿‚ç
i-mobile

‘½‘Α½‚ÌŠÖ˜AðÌÞقłÌSQL‚̏‘‚«•û‚ɂ‚¢‚Ä‹³‚¦‚Ä‚­‚¾‚³‚¢¡

ðÌÞÙ1(ŽÐˆõðÌÞÙ)
ŽÐˆõID | ŽÐˆõ–¼
1 | “c’†

ðÌÞÙ2(Ž‘ŠiðÌÞÙ)
Ž‘ŠiID | Ž‘Ši–¼
1 | •’Ê–Æ‹–
2 | ˆãŽt–Æ‹–

ðÌÞÙ3(ŽÐˆõŽ‘Ši•R•t‚¯Ã°ÌÞÙ)
ŽÐˆõID | Ž‘ŠiID
1 | 1

o—Í‚µ‚½‚¢Œ‹‰Ê(‘S•”‚ÌŽ‘Ši‚ɑ΂·‚餎Јõ¢“c’†£‚Ì—L–³‚ðŒ©‚½‚¢‚Å‚·)
Ž‘Ši–¼ | Ž‘Ši‚Ì—L–³
•’Ê–Æ‹– | —L
ˆãŽt–Æ‹– | –³

œŽ¿–âŽÒ: nemutaiyo
œ¶ÃºÞØ:ºÝËß­°À ²ÝÀ°È¯Ä
› ó‘Ô :I—¹
„¤ ‰ñ“š” : 1/1Œ

¤ÅV‚̉ñ“š‚Ö

¤1 œ ‚¤‚¡‚ñ‚Ç
œ100Îß²ÝÄ Í޽ıݻ°

‚¨Œ¾—t‚Ɋ¦‚Ä“]‹L‚µ‚Ü‚·

SELECT t1.Ž‘Ši–¼
 , (CASE
 WHEN
 EXISTS(
 SELECT
 FROM ŽÐˆõŽ‘Ši•R•t‚¯Ã°ÌÞÙ t2
 WHERE ŽÐˆõID = 1
 AND t2.Ž‘ŠiID = t1.Ž‘ŠiID
 )
 THEN '—L'
 ELSE '–³'
 END
 ) AS Ž‘Ši‚Ì—L–³
FROM Ž‘ŠiðÌÞÙ t1;
ŠÖ˜AŽ¿–â

œŽ¿–â‚ð‚à‚Á‚Æ’T‚·œ



0.l—ÍŒŸõ‚Í‚Ä‚ÈįÌß
8.‚±‚ÌÍß°¼Þ‚ð—F’B‚ɏЉî
9.‚±‚ÌÍß°¼Þ‚̐擪‚Ö
 ‘Ήž‹@Žíˆê——
 ‚¨–â‚¢‡‚킹
 ÍÙÌß/‚¨’m‚点
 Û¸Þ²Ý
 –³—¿Õ°»Þ°“o˜^
 ‚Í‚Ä‚ÈįÌß