Request buckling up in V2.1

[reivi]

Hey there,

We do use an old version of SQLBase (Gupta/Quest v2.1)

And today we did find something "funny" or irritating, depending on who you ask .

requesting between two tables ('aide_dos' and 'aide_exe') both have "dos_refn" in comon

If you request one or another for a value, stat or other, that works, when requesting both at the same time, the prog buckles up .

Any idea where we should have a look ?

in advance, thx

 

[GuptaSteve]

Are you talking about a table join ? Sorry - its not over clear what you mean. If you are querying the two tables in one query , give each table an alias , and join on the common column. eg Select a.blah,b.blah from table1 a , table2 b where a.blah = b.blah


See me at:

http://www.linkedin.com/in/sleighton