<?xml version='1.0' encoding='UTF-8'?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/' xmlns:blogger='http://schemas.google.com/blogger/2008' xmlns:georss='http://www.georss.org/georss' xmlns:gd="http://schemas.google.com/g/2005" xmlns:thr='http://purl.org/syndication/thread/1.0'><id>tag:blogger.com,1999:blog-1305478361028203945</id><updated>2024-11-01T18:21:56.668+07:00</updated><category term="belajar SQL"/><category term="Basic Command SQL"/><category term="Basic SQL"/><category term="Config IIS Seven"/><category term="Error IIS 7"/><category term="Kompatibel IIS 7"/><category term="Union in sql"/><title type='text'>Be Smart and Excellent with IT</title><subtitle type='html'></subtitle><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='http://wisnuananto.blogspot.com/feeds/posts/default'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/1305478361028203945/posts/default?redirect=false'/><link rel='alternate' type='text/html' href='http://wisnuananto.blogspot.com/'/><link rel='hub' href='http://pubsubhubbub.appspot.com/'/><author><name>Wisnu Ananto</name><uri>http://www.blogger.com/profile/03373282707160209213</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='24' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiC_WnXjwiPdZou99RXExI14qKe8DH-E__Tk60mF9Ew49mhNNiFRxclISivdmNF6mkcLKsvl4aBNXp8Hxzf856nWS4CyDPVtsTUYA7bBkA1b2EWTuwsmhTANc8nT44XcEY/s220/DSC03365.JPG'/></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>4</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-1305478361028203945.post-4697567724474489937</id><published>2012-03-03T10:15:00.001+07:00</published><updated>2012-03-03T10:17:16.996+07:00</updated><title type='text'>Join in SQL</title><summary type="text">

Seperti namanya perintah join
berfungsi untuk menggabungkan satu tabel dengan tabel yang lain dengan field
yang sama datanya (Primary key – foreign key).&amp;nbsp;
Akan dibahas satu persatu jenis-jenis perintah join;






&amp;nbsp;Inner Join



Dari beberapa tabel yang
digabungkan, data yang akan ditampilkan hanya data yang key antara beberapa
tabel cocok, jika tidak cocok maka data tidak akan </summary><link rel='replies' type='application/atom+xml' href='http://wisnuananto.blogspot.com/feeds/4697567724474489937/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://wisnuananto.blogspot.com/2012/03/join-in-sql.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/1305478361028203945/posts/default/4697567724474489937'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/1305478361028203945/posts/default/4697567724474489937'/><link rel='alternate' type='text/html' href='http://wisnuananto.blogspot.com/2012/03/join-in-sql.html' title='Join in SQL'/><author><name>Wisnu Ananto</name><uri>http://www.blogger.com/profile/03373282707160209213</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='24' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiC_WnXjwiPdZou99RXExI14qKe8DH-E__Tk60mF9Ew49mhNNiFRxclISivdmNF6mkcLKsvl4aBNXp8Hxzf856nWS4CyDPVtsTUYA7bBkA1b2EWTuwsmhTANc8nT44XcEY/s220/DSC03365.JPG'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjL6-CAovLmrKqLxfVxyBEjZ75tEusR-9ubhpzkNgg2Yr3uSrVEd6W0WRrNQUoeZymmjUWlw0unK7wwq5hlM_h3QmXNQ26mTH3i5FBQ66nAnv0gkCABPSEm5IaN2gk6_d0Y_j0updEV5IeK/s72-c/Inner+Join+hasil.png" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-1305478361028203945.post-4748259400893488180</id><published>2012-02-08T20:16:00.001+07:00</published><updated>2012-03-03T10:30:02.366+07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="belajar SQL"/><category scheme="http://www.blogger.com/atom/ns#" term="Union in sql"/><title type='text'>Union in SQL</title><summary type="text">
Dalam SQL untuk menggabungkan beberapa table selain dengan perintah JOIN, juga dapat dilakukan dengan perintah UNION. Berikut penggunaan perintah Union dalam SQL:




SELECT [table alias].[nama field] ,&amp;nbsp;

&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;[table alias].[nama field] ,

&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;[table alias].[nama field]&amp;nbsp;

FROM (

SELECT</summary><link rel='replies' type='application/atom+xml' href='http://wisnuananto.blogspot.com/feeds/4748259400893488180/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://wisnuananto.blogspot.com/2012/02/union-in-sql.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/1305478361028203945/posts/default/4748259400893488180'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/1305478361028203945/posts/default/4748259400893488180'/><link rel='alternate' type='text/html' href='http://wisnuananto.blogspot.com/2012/02/union-in-sql.html' title='Union in SQL'/><author><name>Wisnu Ananto</name><uri>http://www.blogger.com/profile/03373282707160209213</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='24' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiC_WnXjwiPdZou99RXExI14qKe8DH-E__Tk60mF9Ew49mhNNiFRxclISivdmNF6mkcLKsvl4aBNXp8Hxzf856nWS4CyDPVtsTUYA7bBkA1b2EWTuwsmhTANc8nT44XcEY/s220/DSC03365.JPG'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-1305478361028203945.post-4963171601050708758</id><published>2012-02-08T12:03:00.000+07:00</published><updated>2012-02-09T18:20:40.660+07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Basic Command SQL"/><category scheme="http://www.blogger.com/atom/ns#" term="Basic SQL"/><category scheme="http://www.blogger.com/atom/ns#" term="belajar SQL"/><title type='text'>Basic Command SQL</title><summary type="text">
Saya akan sedikit membahas dasar-dasar perintah SQL, mulai dari Select, Insert, Update, dan Delete, semoga bermanfaat untuk teman-teman yang baru mengenal SQL.



SELECT_________________________________________________________
Fungsi SELECT dalam SQL adalah untuk mengambil data dari suatu table atau view dalam database.

SELECT * FROM [nama tabel]&amp;nbsp;WHERE (Condition)&amp;nbsp;|| untuk menampilkan</summary><link rel='replies' type='application/atom+xml' href='http://wisnuananto.blogspot.com/feeds/4963171601050708758/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://wisnuananto.blogspot.com/2012/02/basic-command-sql.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/1305478361028203945/posts/default/4963171601050708758'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/1305478361028203945/posts/default/4963171601050708758'/><link rel='alternate' type='text/html' href='http://wisnuananto.blogspot.com/2012/02/basic-command-sql.html' title='Basic Command SQL'/><author><name>Wisnu Ananto</name><uri>http://www.blogger.com/profile/03373282707160209213</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='24' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiC_WnXjwiPdZou99RXExI14qKe8DH-E__Tk60mF9Ew49mhNNiFRxclISivdmNF6mkcLKsvl4aBNXp8Hxzf856nWS4CyDPVtsTUYA7bBkA1b2EWTuwsmhTANc8nT44XcEY/s220/DSC03365.JPG'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-1305478361028203945.post-6304272722218571857</id><published>2012-02-08T10:28:00.000+07:00</published><updated>2012-02-09T18:21:35.710+07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="belajar SQL"/><category scheme="http://www.blogger.com/atom/ns#" term="Config IIS Seven"/><category scheme="http://www.blogger.com/atom/ns#" term="Error IIS 7"/><category scheme="http://www.blogger.com/atom/ns#" term="Kompatibel IIS 7"/><title type='text'>Setting Internet Information Service (IIS) 7</title><summary type="text">
Apa itu IIS?
Penjelasan secara singkat IIS atau Internet Information Services atau Internet Information Server adalah sebuah HTTP web server yang digunakan dalam sistem operasi server Windows. Layanan ini berfungsi sebagai pendukung protokol TCP/IP yang berjalan dalam lapisan aplikasi (application layer). IIS juga menjadi fondasi dari platform Internet danIntranet Microsoft, yang mencakup </summary><link rel='replies' type='application/atom+xml' href='http://wisnuananto.blogspot.com/feeds/6304272722218571857/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://wisnuananto.blogspot.com/2012/02/jika-terjadi-error-saat-setting.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/1305478361028203945/posts/default/6304272722218571857'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/1305478361028203945/posts/default/6304272722218571857'/><link rel='alternate' type='text/html' href='http://wisnuananto.blogspot.com/2012/02/jika-terjadi-error-saat-setting.html' title='Setting Internet Information Service (IIS) 7'/><author><name>Wisnu Ananto</name><uri>http://www.blogger.com/profile/03373282707160209213</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='24' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiC_WnXjwiPdZou99RXExI14qKe8DH-E__Tk60mF9Ew49mhNNiFRxclISivdmNF6mkcLKsvl4aBNXp8Hxzf856nWS4CyDPVtsTUYA7bBkA1b2EWTuwsmhTANc8nT44XcEY/s220/DSC03365.JPG'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgsYB6PjdA72YiZFZdyTaiOfcCKX_f4XFgvvynyY8igJo7ST1MhHy8HUuTsbyyt_5xmZcZca1XfNlXaTFxFHas7oFMAwVIuzv6gGeQSs-R-_y0WnSbHymOiUdgSITEW3Q84Wb83IT5y0saU/s72-c/Pic+1.jpg" height="72" width="72"/><thr:total>0</thr:total></entry></feed>