Outer Join Woes

[zunni]

Hi,

I'm having trouble with creating an outer join involving 3 tables. Can someone shed some light for me?

I have three tables:

Tables Columns
--------------------------------------------
Jobs id,type
Action id,type,Job_id
Action_sub_type id,type,Action_id

The tables are joined by these conditions

Jobs.id = Action.Jobs_id
Action.id = Action_sub_type.Action_id

Jobs has a one to many relationship with Action and
Action has a one to many relationship with sub_type

How do I write a query that shows all Jobs.id that do not have these conditions:
Action.type = "This" AND
Action_sub_type.type ="That"

Thanks in advance,
Me.

 

[NiceArms]

you will get a better response:

http://www.tek-tips.com/threadminder.cfm?pid=183

(here)