Re: [GENERAL] question about join

2008-05-01 Thread Osvaldo Kussama
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

Re: [GENERAL] question about join

2008-05-01 Thread Ottavio Campana
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

Re: [GENERAL] question about join

2008-05-01 Thread Osvaldo Kussama
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