2008/5/1 Ottavio Campana <[EMAIL PROTECTED]>:
> Osvaldo Kussama ha scritto:
>
>
> >
> > > To further explain, the following query selects both the rows from the
> join
> > > where id_ref_first_tab has the desired value and default_value = true,
> while
> > > I want to select the row corresponding
Osvaldo Kussama ha scritto:
To further explain, the following query selects both the rows from the join
where id_ref_first_tab has the desired value and default_value = true, while
I want to select the row corresponding to default_value = true only in case
no row corresponding to id_ref_first_ta
2008/5/1 Ottavio Campana <[EMAIL PROTECTED]>:
> Hi, I'm having a problem trying to write a query using join, and I hope you
> can give me a hint.
>
> suppose you have a three tables like these:
>
> create table first_table (
> id serial primary key,
> description1 text);
>
> crea