Hi Brain, Yes, i'd checked that we on the same page in terms of database, i suppose what the question really asking is any order placed before 06-05-1998. return those...

Yep, this make sense, The first one is 9, The second is 830, But what I really want to figure out is how to go about and display this 9...

Hi SS, Sorry for the confusion, what I really struggle was why my solution didn't work, I though at least return something instead of 0. so it would be much...

Hi SS,

Thanks for your answer, but the question ask specifically to use right join and sub query to solve the problem:-)