So I've been searching the web all the past week for some answers. Here's the problem:
On the computer I'm using, suddenly every mpg/avi/Anything NotQuicktime movie I'm trying to watch has turned BLUE. Colors seem to be inversed for the most part, and everything has a blue tint to it. There's a lot of people asking about this problem, but I can't seem to find a solution.
These are videos like the Star Wars EP 3 trailer, and the new Zelda Trailer - both in Windows Media format being screwed up. The only real advice I've found is to try switching from 16 to 32 bit color but that hasn't helped.
This is a one of those LEFT JOIN things, I think. I hate doing LEFT JOIN (outside of getting Access to work it for me.) With Left Join, it's the first table after FROM that you get all the records from. You get the matching records from LEFT JOIN.