On 15 October 2011 12:20, Madhan Kumar <askmad...@gmail.com> wrote: > Hi. > > I have two Tables with the follwing structure > > *EmpTable* > > Empid* * Empname > > 1 * Raja * > > 2 Kumar > > *DeptTable* > > Deptid Deptname Empid > > 101 * xxx* 1 > > 102 *yyy* 1 > > 103 *zzz* 1 > > 104 bbb 2 > > 105 ccc 2 > > i need a Sqlite query to display the data in one row (concatenate the > deptdetail rows in one row instead of 3 rows) > > Empid Empname DeptDetail > > 1 Raja * xx - yy-zz* > > 2 Kumar bbb-ccc > > Thanks
http://www.sqlite.org/lang_aggfunc.html#groupconcat Regards, Simon _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users