[firebird-support] Looking for a special select-statement

Hi, we would need the below shown result-dataset from data shown in Tab1 and Tab2. Can this be expressed with a select-statement? Thank you for your help, Josef Gschwendtner Tab1 Key1 Value1 1 1000 2 2000 3 3000 4 4000 Tab2 Key2

RE: [firebird-support] Looking for a special select-statement

Tab1 Key1   Value1 1  1000 2  2000 3  3000 4  4000   Tab2 Key2   Key1   Value2 1 1   400 2 1   400 3 2 2000 4 3 1000 5 3 1000 6

[firebird-support] Re: Looking for a special select-statement

Hi, this works great, thank you. Josef

[firebird-support] Unable to repair a corrupt database

I have a Firebird 2.5.2 database (ODS 11.2). The database has corrupted. When I open the database, I receive a message page 1577 is of wrong type (expected 4, found 5) I have tried using gfix, gfix -mend, gbak to attempt backup but it doesn't work. I also try if qli may extract the data,

Re: [firebird-support] Unable to repair a corrupt database

Hi, Try to open database with FirstAID Extractor (it's free) and check is there data you are looking inside. Regards, Alexey Kovyazin IBSurgeon I have a Firebird 2.5.2 database (ODS 11.2). The database has corrupted. When I open the database, I receive a message page 1577 is