On Mon, 7 Feb 2005 18:05:02 -0800, Shawn Fletcher SCC
wrote:

FROM (Servers INNER JOIN Printers ON Servers.Server_ID=Printers.Server_ID)
INNER JOIN Server_HDD ON Servers.Server_ID=Server_HDD.Server_ID;

Change the INNER JOINS to LEFT JOIN and you'll see all the servers,
whether thay have printers or HDD's or not.

John W. Vinson[MVP]