I get an Ambiguous column name error with this query (InvoiceID). I can't figure out why. They all seem to be joined correctly so why doesn't the management studio know to display VendorID? Any help would be greatly appreciated.I get an Ambiguous column name error with this