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