An Obama-appointed judge has put the kibosh on a request by Donald Trump's attorneys to stop a subpoena for the president's financial details.