Given the following: create table w (f, t); begin; insert into w (f, t) values (1, 2); insert into w (f, t) values (1, 3); insert into w (f, t) values (1, 4); insert into w (f, t) values (1, 5); insert into w (f, t) values (1, 6); insert into w (f, t) values (1, 7); ... commit;
select t from w where f=1; 2 3 4 5 6 7 I would like the output to look like this: 1 2 3 4 5 6 7 i.e. parent child1 child2 ... childN is there any way to do that with sql or should I just do it in my program? RW ----------Tyco Electronics---------- Ron Wilson, S/W Systems Engineer III 434.455.6453 tycoelectronics.com ------------------------------------ Important: This electronic mail message and any attached files contain information intended for the exclusive use of the individual or entity to which it is addressed and may contain information that is proprietary, privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any viewing, copying, disclosure or distribution of this information may be subject to legal restriction or sanction. Please notify the sender, by electronic mail or telephone, of any unintended recipients and delete the original message without making any copies. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users