{"id":202,"date":"2010-08-14T23:35:25","date_gmt":"2010-08-14T21:35:25","guid":{"rendered":"http:\/\/www.fethimurat.com\/blog\/?p=202"},"modified":"2017-04-16T14:40:27","modified_gmt":"2017-04-16T12:40:27","slug":"join-devam","status":"publish","type":"post","link":"https:\/\/www.fethimurat.com\/blog\/join-devam\/","title":{"rendered":"Join devam"},"content":{"rendered":"<p>Bunun i\u00e7in IlkDB adl\u0131 database&#8217;i restore ediniz.<br \/>\n<a href=\"http:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2010\/08\/JoinDB.zip\">http:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2010\/08\/JoinDB.zip<\/a><\/p>\n<pre class=\"brush:sql\">-- kategoriler tablosu ve urunler tablosu\r\nselect * from Kategoriler\r\nselect * from Urunler\r\n\r\n-- t\u00fcm kategorileri listeleyin e\u011fer varsa \u00fcr\u00fcnlerinin adlar\u0131n\u0131 da listeleyin\r\n\r\nselect k.KategoriAdi,u.UrunAdi\r\nfrom Kategoriler k\r\nleft join Urunler u on k.KategoriID=u.KategoriID\r\n\r\n-- t\u00fcm \u00fcr\u00fcnleri ve varsa dahil olduklar\u0131 kategorilerinin adlar\u0131n\u0131 da getirin\r\nselect u.UrunAdi,k.KategoriAdi\r\nfrom Kategoriler k\r\nright join Urunler u on u.KategoriID=k.KategoriID\r\n\r\n-- tedarikciler tablosu olu\u015ftural\u0131m\r\ncreate table Tedarikciler\r\n(\r\n   TedarikciID int primary key identity(1,1),\r\n   FirmaAdi varchar(50)\r\n)\r\ngo\r\n\r\ninsert into Tedarikciler values('TedA')\r\ninsert into Tedarikciler values('TedB')\r\ninsert into Tedarikciler values('TedC')\r\n\r\nalter table Urunler\r\nadd TedarikciID int references Tedarikciler (TedarikciID)\r\n\r\nselect * from Tedarikciler\r\nselect * from Urunler\r\n\r\n-- kategorisi olmayan \u00fcr\u00fcn\u00fcn tedarikcisi verildi\r\nupdate Urunler set TedarikciID=1\r\nwhere KategoriID is null\r\n\r\n-- br \u00fcr\u00fcn daha tedarikcisiyle birlikte kullan\u0131lacak\r\nupdate Urunler set TedarikciID=3\r\nwhere UrunAdi like '%ace%'\r\n\r\nselect * from Urunler\r\n\r\n-- t\u00fcm tedarikcileri varsa getirdikleri \u00fcr\u00fcnlerin adlar\u0131n\u0131 ve varsa o \u00fcr\u00fcnlerin dahil oldu\u011fu kategori adlar\u0131n\u0131 listeleyin\r\nselect t.FirmaAdi,u.UrunAdi,k.KategoriAdi\r\nfrom Tedarikciler t\r\nleft join Urunler u on u.TedarikciID=t.TedarikciID\r\nleft join Kategoriler k on k.KategoriID=u.KategoriID\r\n\r\n-- urunleri ve kategori isimlerini getirirken varsa urunlerin tedarikci firmas\u0131n\u0131 da getirin\r\nselect k.KategoriAdi,u.UrunAdi,t.FirmaAdi\r\nfrom Kategoriler k\r\njoin Urunler u on u.KategoriID=k.KategoriID\r\nleft join Tedarikciler t on t.TedarikciID=u.TedarikciID\r\n\r\n-- t\u00fcm kategorileri ve t\u00fcm \u00fcr\u00fcnleri getirin e\u011fer varsa \u00fcr\u00fcnlerin tedarikci firmas\u0131n\u0131 da getirin\r\n-- full join\r\nselect k.KategoriAdi,u.UrunAdi,t.FirmaAdi\r\nfrom Kategoriler k full join \r\nUrunler u on u.KategoriID=k.KategoriID\r\nleft outer join Tedarikciler t on t.TedarikciID=u.TedarikciID\r\n\r\n-- t\u00fcm e\u015fle\u015fen urunleri ve urunleri getiren tedarikcilerin adlar\u0131 yan\u0131nda t\u00fcm kategorileri getirin\r\nselect u.UrunAdi,t.FirmaAdi,k.KategoriAdi\r\nfrom Urunler u\r\njoin Tedarikciler t on t.TedarikciID=u.TedarikciID\r\nfull join Kategoriler k on k.KategoriID=u.KategoriID\r\n\r\n--  e\u011fer t\u00fcm tedarikciler t\u00fcm \u00fcr\u00fcnleri getirebiliyor olsayd\u0131 t\u00fcm secenekleri listeleyelim\r\nselect u.UrunAdi,t.FirmaAdi\r\nfrom Tedarikciler t\r\ncross join Urunler u<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Bunun i\u00e7in IlkDB adl\u0131 database&#8217;i restore ediniz. http:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2010\/08\/JoinDB.zip &#8212; kategoriler tablosu ve urunler tablosu select * from Kategoriler select *<\/p>\n","protected":false},"author":14,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[43],"tags":[],"class_list":["post-202","post","type-post","status-publish","format-standard","hentry","category-join-sql","comments-off"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Join devam | F.Murat ALTINI\u015eIK<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.fethimurat.com\/blog\/join-devam\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Join devam | F.Murat ALTINI\u015eIK\" \/>\n<meta property=\"og:description\" content=\"Bunun i\u00e7in IlkDB adl\u0131 database&#8217;i restore ediniz. http:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2010\/08\/JoinDB.zip -- kategoriler tablosu ve urunler tablosu select * from Kategoriler select *\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.fethimurat.com\/blog\/join-devam\/\" \/>\n<meta property=\"og:site_name\" content=\"F.Murat ALTINI\u015eIK\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/muratfethi\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/muratfethi\" \/>\n<meta property=\"article:published_time\" content=\"2010-08-14T21:35:25+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-04-16T12:40:27+00:00\" \/>\n<meta name=\"author\" content=\"F.Murat ALTINI\u015eIK\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@muratfethi\" \/>\n<meta name=\"twitter:site\" content=\"@muratfethi\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"F.Murat ALTINI\u015eIK\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.fethimurat.com\/blog\/join-devam\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/join-devam\/\"},\"author\":{\"name\":\"F.Murat ALTINI\u015eIK\",\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2\"},\"headline\":\"Join devam\",\"datePublished\":\"2010-08-14T21:35:25+00:00\",\"dateModified\":\"2017-04-16T12:40:27+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/join-devam\/\"},\"wordCount\":19,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2\"},\"articleSection\":[\"Join\"],\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.fethimurat.com\/blog\/join-devam\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.fethimurat.com\/blog\/join-devam\/\",\"url\":\"https:\/\/www.fethimurat.com\/blog\/join-devam\/\",\"name\":\"Join devam | F.Murat ALTINI\u015eIK\",\"isPartOf\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#website\"},\"datePublished\":\"2010-08-14T21:35:25+00:00\",\"dateModified\":\"2017-04-16T12:40:27+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/join-devam\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.fethimurat.com\/blog\/join-devam\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.fethimurat.com\/blog\/join-devam\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ana sayfa\",\"item\":\"https:\/\/www.fethimurat.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Join devam\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#website\",\"url\":\"https:\/\/www.fethimurat.com\/blog\/\",\"name\":\"F.Murat ALTINI\u015eIK\",\"description\":\"HTML | PHP | C# | SQL | ASP.net | Bitcoin\",\"publisher\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.fethimurat.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2\",\"name\":\"F.Murat ALTINI\u015eIK\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2018\/01\/xxx-150x150.jpg\",\"contentUrl\":\"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2018\/01\/xxx-150x150.jpg\",\"caption\":\"F.Murat ALTINI\u015eIK\"},\"logo\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/image\/\"},\"description\":\"1973 yilinda Balikesir\u2019de dogdum. Ilkokulu Gazi (Ilk\u00f6gretim) Ilk Okulu, Orta okulu ise Karesi Ortaokulunda okudum. Orta okulda merak sardigim elektronige nihayet elektronik b\u00f6l\u00fcm\u00fcn\u00fc kazanarak dijital elektronik ile giris yaptim. Bilgisayar hobim o zamanlarda herkes gibi Commadore 64'lerle baslayip Amigalar ile devam etti.Amat\u00f6r olarak Clipper programciligi yaptim. Donanim ve network konularinda uzmanlasmaya \u00e7alistim. Webtasarim ile ilgili konularda yaptigim \u00e7alismalardan sonra yazilim olan merakim daha da arti, su an c# ve sql \u00fczerindeki \u00e7alismalarim devam etmektedir. UZMANLIK: - MS Ofis Programlari - Adobe Photoshop - Macromedia Flash, Macromedia Dreamweaver - MS Visual Studio - MSSQL, MYSQL - WAN\/LAN , TCP\/IP, DNS, DHCP , VPN - Active Directory tasarim, kurulum ve y\u00f6netim teknikleri - ISA Server - Windows Server\",\"sameAs\":[\"http:\/\/www.fethimurat.com\",\"https:\/\/www.facebook.com\/muratfethi\",\"https:\/\/www.instagram.com\/muratfethi\/\",\"https:\/\/www.linkedin.com\/in\/murat-altiniik-24119a13a\/\",\"https:\/\/x.com\/muratfethi\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Join devam | F.Murat ALTINI\u015eIK","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.fethimurat.com\/blog\/join-devam\/","og_locale":"tr_TR","og_type":"article","og_title":"Join devam | F.Murat ALTINI\u015eIK","og_description":"Bunun i\u00e7in IlkDB adl\u0131 database&#8217;i restore ediniz. http:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2010\/08\/JoinDB.zip -- kategoriler tablosu ve urunler tablosu select * from Kategoriler select *","og_url":"https:\/\/www.fethimurat.com\/blog\/join-devam\/","og_site_name":"F.Murat ALTINI\u015eIK","article_publisher":"https:\/\/www.facebook.com\/muratfethi","article_author":"https:\/\/www.facebook.com\/muratfethi","article_published_time":"2010-08-14T21:35:25+00:00","article_modified_time":"2017-04-16T12:40:27+00:00","author":"F.Murat ALTINI\u015eIK","twitter_card":"summary_large_image","twitter_creator":"@muratfethi","twitter_site":"@muratfethi","twitter_misc":{"Yazan:":"F.Murat ALTINI\u015eIK","Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.fethimurat.com\/blog\/join-devam\/#article","isPartOf":{"@id":"https:\/\/www.fethimurat.com\/blog\/join-devam\/"},"author":{"name":"F.Murat ALTINI\u015eIK","@id":"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2"},"headline":"Join devam","datePublished":"2010-08-14T21:35:25+00:00","dateModified":"2017-04-16T12:40:27+00:00","mainEntityOfPage":{"@id":"https:\/\/www.fethimurat.com\/blog\/join-devam\/"},"wordCount":19,"commentCount":0,"publisher":{"@id":"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2"},"articleSection":["Join"],"inLanguage":"tr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.fethimurat.com\/blog\/join-devam\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.fethimurat.com\/blog\/join-devam\/","url":"https:\/\/www.fethimurat.com\/blog\/join-devam\/","name":"Join devam | F.Murat ALTINI\u015eIK","isPartOf":{"@id":"https:\/\/www.fethimurat.com\/blog\/#website"},"datePublished":"2010-08-14T21:35:25+00:00","dateModified":"2017-04-16T12:40:27+00:00","breadcrumb":{"@id":"https:\/\/www.fethimurat.com\/blog\/join-devam\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.fethimurat.com\/blog\/join-devam\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.fethimurat.com\/blog\/join-devam\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ana sayfa","item":"https:\/\/www.fethimurat.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Join devam"}]},{"@type":"WebSite","@id":"https:\/\/www.fethimurat.com\/blog\/#website","url":"https:\/\/www.fethimurat.com\/blog\/","name":"F.Murat ALTINI\u015eIK","description":"HTML | PHP | C# | SQL | ASP.net | Bitcoin","publisher":{"@id":"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.fethimurat.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":["Person","Organization"],"@id":"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2","name":"F.Murat ALTINI\u015eIK","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2018\/01\/xxx-150x150.jpg","contentUrl":"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2018\/01\/xxx-150x150.jpg","caption":"F.Murat ALTINI\u015eIK"},"logo":{"@id":"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/image\/"},"description":"1973 yilinda Balikesir\u2019de dogdum. Ilkokulu Gazi (Ilk\u00f6gretim) Ilk Okulu, Orta okulu ise Karesi Ortaokulunda okudum. Orta okulda merak sardigim elektronige nihayet elektronik b\u00f6l\u00fcm\u00fcn\u00fc kazanarak dijital elektronik ile giris yaptim. Bilgisayar hobim o zamanlarda herkes gibi Commadore 64'lerle baslayip Amigalar ile devam etti.Amat\u00f6r olarak Clipper programciligi yaptim. Donanim ve network konularinda uzmanlasmaya \u00e7alistim. Webtasarim ile ilgili konularda yaptigim \u00e7alismalardan sonra yazilim olan merakim daha da arti, su an c# ve sql \u00fczerindeki \u00e7alismalarim devam etmektedir. UZMANLIK: - MS Ofis Programlari - Adobe Photoshop - Macromedia Flash, Macromedia Dreamweaver - MS Visual Studio - MSSQL, MYSQL - WAN\/LAN , TCP\/IP, DNS, DHCP , VPN - Active Directory tasarim, kurulum ve y\u00f6netim teknikleri - ISA Server - Windows Server","sameAs":["http:\/\/www.fethimurat.com","https:\/\/www.facebook.com\/muratfethi","https:\/\/www.instagram.com\/muratfethi\/","https:\/\/www.linkedin.com\/in\/murat-altiniik-24119a13a\/","https:\/\/x.com\/muratfethi"]}]}},"_links":{"self":[{"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/posts\/202","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/users\/14"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/comments?post=202"}],"version-history":[{"count":0,"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/posts\/202\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/media?parent=202"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/categories?post=202"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/tags?post=202"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}