How to select from different databases?

Question

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

arpp Grasshopper Points: 14 More actions · Answer 1

try this...

SELECT T.EmployID, T.Batch_Num, U.LASTNAME, U.FRSTNAME

FROM HFC_Epay.dbo.EPay_Transaction_Table T INNER JOIN

HFC.dbo.UPR00100 U ON T.EmployID = U.EMPLOYID

WHERE (T.Batch_Num =

(SELECT MAX(HFC_Epay.dbo.Epay_Traction_Table.batch_num)

FROM HFC_Epay.dbo.Epay_Traction_Table))

David Bytheway SSC-Addicted Points: 457 More actions · Answer 2

Could it be that you meant to spell Traction as Transaction in the final FROM clause ?

DKSINGH SSC Eights! Points: 921 More actions · Answer 3

No Its Transaction i believe...... Just one changes ... MAX(HFC_Epay.dbo.Epay_Traction_Table.batch_num) instead of MAX(batch_num)

Tom Goltl SSCertifiable Points: 5815 More actions · Answer 4

Are you sure dbo is the owner of the table.

I would open enterprise manager and confirm dbo owns the tables. I have worked on some systems that they gave the tables owners other than dbo.

Let us know.

Tom

arpp Grasshopper Points: 14 More actions · Answer 5

if not sure of who the owner is just use

MAX(HFC_Epay..Epay_Traction_Table.batch_num) instead of MAX(batch_num).