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
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
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
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