Re: [firebird-support] How to join records

2015-02-17 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Feb 17, 2015, at 7:26 AM, Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support] firebird-support@yahoogroups.com wrote: Could Common Table Expressions or Derived Tables bring any advantages? I suppose you could use a combination of the two suggestions: [good

Re: [firebird-support] How to join records

2015-02-16 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Feb 16, 2015, at 4:22 AM, josef.gschwendt...@quattro-soft.de [firebird-support] firebird-support@yahoogroups.com wrote: we have 2 tables For each record in Table1 there are 2 records in Table2. Table1 (T1) == 1 2 Table2 (T2) T2T1 == 11 21 3

Re: [firebird-support] How to join records

2015-02-16 Thread Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support]
On Feb 16, 2015, at 4:22 AM, josef.gschwendt...@quattro-soft.de [firebird-support] firebird-support@yahoogroups.com wrote: we have 2 tables For each record in Table1 there are 2 records in Table2. Table1 (T1) == 1 2 Table2 (T2) T2T1 == 11 21 32

[firebird-support] How to join records

2015-02-16 Thread josef.gschwendt...@quattro-soft.de [firebird-support]
Hi, we have 2 tables For each record in Table1 there are 2 records in Table2. Table1 (T1) == 1 2 Table2 (T2) T2T1 == 11 21 32 42 What is the cheapest way to get a dataset like below? T1T2aT2b === 1 12 2 34