Tim-
AFAIK it is:
<cfquery name="getBooks" datasource="publishers">
select pub.dbo.publisherInfo.name, books.dbo.titles.title
from pub.dbo.publisherInfo, books.dbo.titles
</cfquery>
You do the name of the datasource first, then "dbo", then the table name...