Path: utzoo!utgpu!jarvis.csri.toronto.edu!mailrus!tut.cis.ohio-state.edu!cs.utexas.edu!uunet!mcsun!cernvax!hslrswi!aut!oechslin
From: oechslin@aut.UUCP (Oechslin Stephan)
Newsgroups: comp.databases
Subject: informix-sql join problems
Keywords: informix-sql
Message-ID: <709@aut.UUCP>
Date: 4 Sep 89 13:14:46 GMT
Organization: ascom AUTELCA AG, CH-3073 Guemligen Switzerland
Lines: 44

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