I was wrong. Your WHERE condition doesn't make any sense if you want to use FULL JOIN for all tables. What are you trying to acomplish?
>
>Are you telling me "No" it can't be done, or it can't be done the way I currently have my statement?
>
>You say I should move my condtions from the WHERE tot he JOIN(s), does that mean I have specify my criteria in each join condition along with the join condition like so:
>
--sb--