Wala ko ka gets kaayo sa imo pasabot. Namataka lang ko ani, pero basin makatabang pero ambot lang unsaon gyud na imong pasabot ....
SELECT (SELECT name from table1 where id=1) as Field1, (SELECT name from table2 where id=1) as Field2 ... and so on ??? ingana? On 5/18/07, Jason Yap <[EMAIL PROTECTED]> wrote:
Hi guys. Naa ko pangutana about sql query ang gusto nako mahitabo kay unsaon pagbutang sa isa ka row ang multiple results sa usa ka query without using php. example: kung sa normal query, ang results would be: a,b,c,d,e where each result is a row. ang gusto nako mahitabo kay query gihapon, same result, a,b,c,d,e, but in one row nlang. Is this possible in mysql without using php? Any help will be appreciated. Thanks :) -- "Just being alive is such a lovely and wonderful thing." _________________________________________________ Kagay-Anon Linux Users' Group (KLUG) Mailing List [email protected] (http://cdo.linux.org.ph) Searchable Archives: http://archives.free.net.ph
-- -- Live free. Love free. http://mungkey.deviantart.com http://mungkey.blogspot.com
_________________________________________________ Kagay-Anon Linux Users' Group (KLUG) Mailing List [email protected] (http://cdo.linux.org.ph) Searchable Archives: http://archives.free.net.ph
