Re: [GENERAL] query for all values linked to a field

2011-12-13 Thread anisoptera
Merlin Moncure-2 wrote > > > I didn't quite parse that.Using recursive queries, it should be > able to pretty easily query out, given a table name, all tables that > link to that table and the columns of the keys in the constraints > (and, if necessary, the links from other tables to those t

Re: [GENERAL] query for all values linked to a field

2011-12-13 Thread Merlin Moncure
On Tue, Dec 13, 2011 at 2:37 PM, anisoptera wrote: > hi, > > i'm trying to output all values that can be reached from a specific record > by a foreign key link. > > for example, if tblimage has image_id, image_info and tblstack has > stack_id=tblimage.image_id, stack_info_1, stack_info_2 > i want

[GENERAL] query for all values linked to a field

2011-12-13 Thread anisoptera
hi, i'm trying to output all values that can be reached from a specific record by a foreign key link. for example, if tblimage has image_id, image_info and tblstack has stack_id=tblimage.image_id, stack_info_1, stack_info_2 i want to be able to get image_id, image_info, stack_info_1, stack_info_2