On Tue, Dec 8, 2009 at 11:53 AM, Damo Drumm <damien.dr...@quinn-group.com>wrote:
> > The company table represents the seller, and the Customer table represents > the individual Buyers. > Invoice_Number is unique but I also have INVOICE_Key in the INVOICE table > > If that is the case then the query should work COMPANY <-> INVOICE <-> CUSTOMER This is how the information is joined. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328962 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
