, June 27, 2003 5:10 PM
Subject: Re: [SQL] Getting all rows even if not a member of any groups
> On Fri, Jun 27, 2003 at 16:18:10 +0200,
> Együd Csaba <[EMAIL PROTECTED]> wrote:
> >
> > This is absolutelly what I want, but I can't understand how it is
working.
> &
On Fri, Jun 27, 2003 at 16:18:10 +0200,
Együd Csaba <[EMAIL PROTECTED]> wrote:
>
> This is absolutelly what I want, but I can't understand how it is working.
> Where can I find a descriptive (tale-like, for kids ... :) ) documentation
> about using joins?
If you look at the documentation for th
Bruno,
> Please don't reply to messages to start a new thread.
sorry, I will never do such things in the future.
> select t_productgroups.name as pgroup,
> t_products.id as productid
> from t_products
> left join (t_prod_in_pgr
> join t_productgroups on (t_productgroups.id =
On Fri, Jun 27, 2003 at 13:13:07 +0200,
Együd Csaba <[EMAIL PROTECTED]> wrote:
> Hi,
Please don't reply to messages to start a new thread.
> I have a product table identified by its id field. There is a productgroups
> table with productisd, productgroupid fields. And I have a prod_in_pgr
> (pr
Hi,
I have a product table identified by its id field. There is a productgroups
table with productisd, productgroupid fields. And I have a prod_in_pgr
(productid, productgroupid) table which describes the membership of
productgroups. Each product can be a member of zero or more productgroups,
but o
