hello,

i have some ASP pages that i am using to pull up VFP data on our intranet. i am trying to do the following SQL select statement which works fine in VFP

SELECT COUNT(*) FROM UNIQUECUST!UNIQUECUST U JOIN CS21!TRANSACTIONS T ON U.CUSTID=T.CUSTID

i am selecting data from tables in different databases. i am able to do multi table SELECTs in my ASP pages as long as both tables are in the same database.

help!

n.