Comparing 2 Fields Query

[ekryez]

Trying to Compare 2 fields Status with answers Yes or No, from 2 Tables PipeLine and Pipe, and get the fields that don't match, what am i doing wrong?
SELECT PipeLine.[Project Name], PipeLine.[Capacity DC], PipeLine.[Project Num], PipeLine.[Status]
FROM PipeLine LEFT JOIN Pipe ON PipeLine.[Project Name] = Pipe.[Project Name]
WHERE (((Pipe.[Status]) ="Yes");

 

[namliam]

Where pipe.status <> Pipeline.status

???

May be a good idea to review: http://www.access-programmers.co.uk/forums/showthread.php?t=225837&highlight=name+convention