Why will it return twice (ID 3,4)? It will return only once even if you use an OR. I am not able to catch your question. What is the end result you require through the query?
–
anonyApr 27 '12 at 10:20

The end result would be to display the week multiple times based on what its greater than, but at the same time whether it exists in another table. I'm currently trying it in a UNION like @Sirko said, but I'm unsure whether this will work or not due to EXISTS and NOT EXISTS further on in the query.
–
BennyCApr 27 '12 at 10:23

+1'd your answer due to the nature of it being correct, although I'm not too sure whether it will work in my situation. Currently trying it at the moment, I'll let you know the result.
–
BennyCApr 27 '12 at 10:24

2

@BennyC It doesnt work ... and try union all instead of union. It still returns only for id =4 twice. :)
–
anonyApr 27 '12 at 10:28

Works brilliantly, just got to further limit it down by further parameters. Thank you for the help.
–
BennyCApr 27 '12 at 10:36