[comp.databases] informix-sql join problems

oechslin@aut.UUCP (Oechslin Stephan) (09/04/89)

hi folks,

I've got some join problems with informix-sql. The problem is best descrbed
using the following example.

contents of myform.per:

<stuff deleted>

field1 = table1.col1 = table2.col1;
field2 = table1.col2 = table2.col2;

instructions

composites  <table1.col1 , table1.col2>
               <table2.col1 , table2.col2>

end
<EOF>

The problem:

I start perform with myform. table1 is the active table. I start a query.
I get as first row: 
     
     field1 = 1        and    field2 = 17

I select table2 as the active table. I start a query. I get as first row:

     field1 = 1        and    field2 = 20

The problem is that there is no such row in table1 !! What happened to
the join?

Anyone an idea?

Thanks for your help.


stephan.

e-mail: oechslin@aut.UUCP