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 'Cross dependency found in OUTER JOIN' error. I could
connect A and B with INNER JOIN but it's useless from my point of view.
I think the problem could be solved with redesigning the database
structure, but it's currently not possible.
Does somebody know a good (general) solution for this? Temporary
tables could help, but i deal with lot's of data and I'm afraid it would
be very slow.
Thanks!
Christian Fischer
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
