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
