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 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users