Re: Multi-level JOIN query

2001-04-08 Thread nigga mysql
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

Multi-level JOIN query

2001-04-07 Thread Christian Fischer
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

Re: Multi-level JOIN query

2001-04-07 Thread Bob Hall
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