Hello.
Your question isn't clear enough for me. Do you want that values in 'type' column of the first table to become column names in the second table? Or do you want just to see results in a row? $$ $ <[EMAIL PROTECTED]> wrote: > [-- text/plain, encoding 8bit, charset: gb2312, 17 lines --] > > My table is: > type price > car 1000 > bike 100 > > > I want the result: > > car bike > 1000 100 > > I don't know how to get that result. > > > --------------------------------- > DO YOU YAHOO!? > $$$$$$$$$$$2G$$$$$pop3$$$$$$$$$$ -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]