Thanks Dave - that sorted it! I guessed it was something fairly straightforward that I just wasn't seeing!!! I'm badly out of practice these days at writing anything more complex than Select * from MyTable where x = y <g>
John Weller 01380 723235 07976 393631 > > John, > Change all your joins on the Suppliers and Locations tables to be "left > Joins" not "inner joins". > > Dave Crozier _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
