> --- [EMAIL PROTECTED] wrote:
>
> > Hi all,
> > I have been working on this Informix SQL query which has an outer
> join.
> > I have attached Informix query and my "supposedly" solution to this
> query
> > but I cannot get the same count. I appreciate for any help.
> > Thanks.
> >
> > --Informix
--- [EMAIL PROTECTED] wrote:
> Hi all,
> I have been working on this Informix SQL query which has an outer join.
> I have attached Informix query and my "supposedly" solution to this query
> but I cannot get the same count. I appreciate for any help.
> Thanks.
>
> --Informix query
> select count
PROTECTED] On Behalf Of
> [EMAIL PROTECTED]
> Sent: Monday, November 06, 2006 4:11 PM
> To: pgsql-sql@postgresql.org
> Subject: [SQL] converting Informix outer to Postgres
>
> Hi all,
> I have been working on this Informix SQL query which has an
> outer join.
> I have at
Hi all,
I have been working on this Informix SQL query which has an outer join.
I have attached Informix query and my "supposedly" solution to this query
but I cannot get the same count. I appreciate for any help.
Thanks.
--Informix query
select count(u.id)
from user u, invention i, inv_contracts
