--- In firebird-support@yahoogroups.com, JoshCooper@u... wrote:

>
> We have a winner!

I have a doubt :))

> SELECT a.ASSY_CODE FROM MATRIX m
> INNER JOIN MATRIX_CELL_ASSY mca
> ON m.MATRIX_ID = mca.MATRIX_ID
> INNER JOIN ASSEMBLY a
> ON mca.ASSY_ID = a.ASSY_ID
>
> WHERE MATRIX_LIB_ID = 3 And MATRIX_ID = 87
> and a.ASSY_LIB_ID = mca.ASSY_LIB_ID
>

"tractaylor" made similar to my mistake by inattention - moved Join
condition to Where clause. As a result we have mix of SQL92 and SQL89
syntax. Sometimes such a queries works. But only sometimes, more usual
is wrong result set.
Draw 1:1 ? ;)

Best regards,
Alexander.