Thanks Set for starting me on the right track. Please see my finalized query
below which gets me to the expected result.
Good to see that you got the result you wanted, Bhavbhuti! I do have two
comments regarding your final result:
1) Why do you use ORDER BY within the CTEs? In the outer
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
I am still trying to find a way to unlock a record when the PC that
locked it (using SELECT ... WITH LOCK) hanged...
I thought the following:
The user who executed the SELECT ... WITH LOCK started a transaction.
When his PC hanged, this transaction remains active.
Is there a way to identify
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