{"id":110,"date":"2011-10-02T11:37:33","date_gmt":"2011-10-02T11:37:33","guid":{"rendered":"http:\/\/sql.programisius.lt\/?page_id=110"},"modified":"2011-10-02T11:37:33","modified_gmt":"2011-10-02T11:37:33","slug":"10-isorinis-lenteliu-apjungimas","status":"publish","type":"page","link":"http:\/\/sql.programisius.lt\/?page_id=110","title":{"rendered":"10. I\u0161orinis lenteli\u0173 apjungimas"},"content":{"rendered":"

Vidinis lenteli\u0173 apjungimas susieja duomenis tik tuos, kurie
\nyra abejose lentel\u0117se. Tuo tarpu gali b\u016bti, kad ka\u017ekurioje i\u0161 apjungiam\u0173j\u0173
\nlenteli\u0173 yra daugiau duomen\u0173 eilu\u010di\u0173, o kitoje tiesiog tr\u016bksta duomen\u0173. \u0160ioje
\nvietose padeda i\u0161orinis OUTTER lenteli\u0173 apjungimas. Apjungiant 2 lenteles
\ngalima prijungti pirm\u0105j\u0105 prie antrosios arba atvirk\u0161\u010diai antr\u0105j\u0105 prie
\npirmosios. Tokiame apjungime jei prijungiama lentel\u0117 neturi s\u0105lygos atitinkan\u010di\u0173
\nduomen\u0173, juos u\u017epildo NULL duomenimis.<\/p>\n

Apjungimas i\u0161 kair\u0117s \u012f de\u0161in\u0119 arba prie pirmos prijungti antr\u0105j\u0105
\nyra nurodoma su LEFT. Atvirk\u0161\u010dias variantas b\u016bt\u0173 arba sukeisti lenteles vietomis
\nu\u017eklausoje arba pakeisti LEFT \u012f RIGHT.<\/p>\n

Pavyzd\u017eiui turime dvi lenteles A ir B:<\/p>\n

Lentel\u0117 A<\/p>\n\n\n\n\n\n
S1<\/strong><\/td>\nS2<\/strong><\/td>\n<\/tr>\n
1<\/td>\nI<\/td>\n<\/tr>\n
2<\/td>\nII<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

Lentel\u0117 B<\/p>\n\n\n\n\n
T1<\/strong><\/td>\nT2<\/strong><\/td>\n<\/tr>\n
1<\/td>\na<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

Apjungtos lentel\u0117s i\u0161 kair\u0117s:<\/p>\n

SELECT S1, S2, T1, T2 FROM A LEFT JOIN ON (S1=T1);<\/p><\/blockquote>\n\n\n\n\n\n
S1<\/strong><\/td>\nS2<\/strong><\/td>\nT1<\/strong><\/td>\nT2<\/strong><\/td>\n<\/tr>\n
1<\/td>\nI<\/td>\n1<\/td>\na<\/td>\n<\/tr>\n
2<\/td>\nII<\/td>\nNULL<\/td>\nNULL<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

U\u017eduotys <\/strong><\/p>\n

1. Suraskite u\u017esakym\u0105, kuris yra anoniminis ir n\u0117ra joki\u0173 duomen\u0173 apie pat\u012f klient\u0105.<\/p>\n","protected":false},"excerpt":{"rendered":"

Vidinis lenteli\u0173 apjungimas susieja duomenis tik tuos, kurie yra abejose lentel\u0117se. Tuo tarpu gali b\u016bti, kad ka\u017ekurioje i\u0161 apjungiam\u0173j\u0173 lenteli\u0173 yra daugiau duomen\u0173 eilu\u010di\u0173, o kitoje tiesiog tr\u016bksta duomen\u0173. \u0160ioje vietose padeda i\u0161orinis OUTTER lenteli\u0173 apjungimas. Apjungiant 2 lenteles galima prijungti pirm\u0105j\u0105 prie antrosios arba atvirk\u0161\u010diai antr\u0105j\u0105 prie pirmosios. Tokiame apjungime jei prijungiama lentel\u0117 neturi […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":13,"menu_order":10,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-110","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=\/wp\/v2\/pages\/110","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=110"}],"version-history":[{"count":1,"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=\/wp\/v2\/pages\/110\/revisions"}],"predecessor-version":[{"id":111,"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=\/wp\/v2\/pages\/110\/revisions\/111"}],"up":[{"embeddable":true,"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=\/wp\/v2\/pages\/13"}],"wp:attachment":[{"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=110"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}