loops ability

[Michel Mironov]

I have two tables:

CREATE TABLE `auth_groups` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(100) default NULL,
`description` text,
PRIMARY KEY (`id`),
KEY `id` (`id`)
) TYPE=InnoDB;

CREATE TABLE `auth_groupgroup` (
`parent` int(11) default NULL,
`child` int(11) default NULL,
KEY `parent` (`parent`),
KEY `child` (`child`),
FOREIGN KEY (`child`) REFERENCES `auth_groups` (`id`),
FOREIGN KEY (`parent`) REFERENCES `auth_groups` (`id`)
) TYPE=InnoDB;

Can I select all groups, witch contain all subgroups? even when exists groups at third level

Maybe need use skilful JOIN?



Edited 2 time(s). Last edit at 10/24/2005 01:18AM by Michel Mironov.