Tricky SQL

From: Randi Wølner <randiwolner_at_hotmail.com>
Date: Mon, 18 Jun 2001 09:35:25 +0200
Message-ID: <9gkavt$acp$1@oslo-nntp.eunet.no>

I have a quesetion about joining tables:

I have one starting table, and then I am going "through" 3-4 other tables by joining columns to the table that I am actually looking for some results in. But - as the model is now, there are four different "ways" to get to the result table, and these four do not include exactly the same tables.

Is there any smart way to avoid join with one specific table, in the cases where there should be no link to it?
(if so - I could probably solve this by using one query and have different OR-parts in the WHERE-clause)

Otherwise I guess I will have to use all four queries, with UNION between them..

Thanks,
Randi Wølner Received on Mon Jun 18 2001 - 02:35:25 CDT