>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.
Nancy,
When selecting from different databases specify the fullpath. ie :
dbpath = Server.MapPath("data")
cSQL = "SELECT COUNT(*) " & _
" FROM " & dbpath & "\UNIQUECUST!UNIQUECUST U " & _
" JOIN " & dbpath & "\CS21!TRANSACTIONS T ON U.CUSTID=T.CUSTID"
Cetin