How to split the sql output into two different variables

view full story

http://www.unix.com – Hi, How to set as variable from sql output. Query: Code: select aa.serial, ao.name from ann_amit aa JOIN ann_object ao on (aa.classid=ao.classid); I got two values from aa.serial and ao.name, I wanna make two different variable for aa.serial and ao.name. The value of aa.serial should be in one variable and The value of ao.name should be in another variable How i should do from shell script, please let me know (HowTos)