Aku udah tes pakai SELECT .. FROM t1 LEFT JOIN t2 ... LEFT JOIN t3 ... dst.
nggak bisa. Itupun sudah pakai MySQL 4.1.5-gamma yang ada di CD MySQL tulisan Bung Steven. Keluarnya, ya seperti biasa You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 Maksudku dalam kurung adalah begini: SELECT * FROM tabel1 LEFT JOIN (tabel2 JOIN tabel3) Itu bisa. Tapi kalau pakai SELECT * FROM tabel1 LEFT JOIN (tabel2 LEFT JOIN tabel3) nggak bisa. Intinya kalau JOIN dimasukkan dalam kurung nggak masalah. Tapi kalau tipe join yang lain, nggak bisa. Maksud bisa dan nggak bisa itu dari syntaks MySQL yah, nggak peduli hasilnya bagaimana dulu. LuckyGuy354 IT Beginner ----- Original Message ----- From: "Steven Haryanto" <[EMAIL PROTECTED]> > pakek kurung gimana sih maksudnya? sintaks SQL ya begitu, kalo ingin > JOIN ya tambah klausa JOIN di belakangnya: > > SELECT .. FROM t1 LEFT JOIN t2 ... LEFT JOIN t3 ... dst. > > bukannya > > SELECT .. FROM t1 LEFT JOIN (t2, t3, ...) -- gk ada sintaks kayak gini > > memang aturan bahasa SQL kayak gitu :) ------------------------ Yahoo! Groups Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12hsdcc3a/M=362335.6886445.7839731.1510227/D=groups/S=1705005512:TM/Y=YAHOO/EXP=1123045387/A=2894361/R=0/SIG=13jmebhbo/*http://www.networkforgood.org/topics/education/digitaldivide/?source=YAHOO&cmpgn=GRP&RTP=http://groups.yahoo.com/";>In low income neighborhoods, 84% do not own computers. At Network for Good, help bridge the Digital Divide!</a>.</font> --------------------------------------------------------------------~-> ---------------------------------------------------------- Komunitas MasterWeb Indonesia http://www.master.web.id ---------------------------------------------------------- MWN, Masternya WEBHOSTING di Indonesia, Indo/USA Servers, Customer Support 24 jam http://www.masterwebnet.com ---------------------------------------------------------- WebDevelopment,Designing/Programming http://www.dlanet.com ---------------------------------------------------------- Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/milis-masterweb/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
