(DBMS: Access)<BR>Here's the From clause of my SQL statement:<BR><BR>[code language="T-SQL"]<BR><BR>FROM (((((Quote INNER JOIN Customer ON Quote.Customer = Customer.Customer)<BR> LEFT JOIN Quote_Qty ON Quote.Quote = Quote_Qty.Quote) <BR> LEFT JOIN Quote_Addl_Charge ON Quote.Quote = Quote_Addl_Charge.Quote)<BR> INNER JOIN Contact On Quote.Contact = Contact.Contact) <BR> INNER JOIN Address A1 On Quote.Ship_To = A1.Address) <BR> INNER JOIN Address A2 On Contact.Address = A2.Address, RptPref<BR><BR>[/code]<BR><BR>I want to include the table RptPref. This table has one record and about 20 columns and stores things like the header and footer text for all the standrad reports like quote,po,etc. Basically, I want this text and I figured it would be less overhead to tack it on to every record then to run a seperate SQL statement. <BR><BR>I can do it just like I listed above if the two LEFT joins are INNER joins. Once I changed them to LEFT joins access gives me a "syntax error in FROM clause" error. <BR><BR>Any ideas about how I would go about including the RptPref table in a standard cartesian join?