I need to do a SQL Outer Join information from three different tables and display the results on a page and I can't figure out how to write the query in a single SQL method. I can't create a temporary table due to tight disk space. Any suggestions? Thanks Steven Grimes Database Engineer sgrimes@atinucleus.com Accelerated Technology, Inc. Mobile, AL www.atinucleus.com ------------------------------------------------------------ "Nucleus. All You NEED in an RTOS. Royalty Free." ------------------------------------------------------------