Your absolutely right, my question was not clearly
specified. So here's a concrete problem:
Let's say table A has 2 fields: PRODUCT_ID (unique) and
PRODUCT_NAME,
table B has 3 fields: PRODUCT_ID,COMPANY_ID and
LAST_PRODUCTION_DATE,
and finally table C : COMPANY_ID and CONTACT_INFO
Table A is the
Hi!
I need some suggestions about a special query. The situation is:
There are (for simplicity) 4 tables: A,B,C and D which must be joined
like this:
Between A and B must be an outer-join association and C and D must
be connected to B also with outer-join.
But this causes a
Hi!
I need some suggestions about a special query. The situation is:
There are (for simplicity) 4 tables: A,B,C and D which must be joined
like this:
Between A and B must be an outer-join association and C and D must
be connected to B also with outer-join.
But this causes a