word choice - What is the difference between 'next to' and 'by'?

There was a table by the window. / There was a table next to the window.

They live by the lake. / They live next to the lake.

When should you use by and when next to? Why?