[SQL] Searching for results with an unknown amount of data

Hi, I've got two tables, A and B, the first one containing columns A_ID | info where A_ID is primary, so that this table stores various information about an object, and the second containing columns A_ID | property where property is an integer referring to a particular property that an object

Re: [SQL] joins again

Hi, You may find examples in the section 'Joining Tables' of Bruce Momjian's marvelous work. http://www.postgresql.org/docs/aw_pgsql_book/node63.html I hope this helps. Regards Erol CB wrote: > Hi, > > Can someone tell me which (if any) joins are supported with 7? It > appears the answer is 'n

Re: Antw: [SQL] LEFT JOIN

Antti Linno wrote: > > > I think, the following select will solve your problem > > > > select first.id > > from first > > except > > second.id_first > > from second; > > > Nay, I got parse error. 'select' is missing after 'except'. select first.id from first except select second.id_firs

Re: [SQL] Finding entries not in table..differnce?

If I understand you exactly, you may use except: select distinct * from prodlang except select distinct * from prodlang2 gives you the records which exist in prodlang and do not exist in prodlang2. So you get all the records in prodlang which are newly inserted or updated. regards erol Zot O'C