Retrieving Data from multiple database

[Anon]

programming language : asp & vbscript
database : sql server 7
problem : I want to retreive data from two database. my personal data on HR database and transaction data on leave database. I want to select leave data based on employee name. Leave data is on leave database and employee nama is on HR database.

HR database
fields - employee_no, empployee_name, address, birth date

leave database
fields - employee_no, leave_code, start_date, end_date, no_of_day, reason, approver

Please solve this problem

[bastien]

are they really different DB or just in different tables...it looks like the same type of dataset (HR related) so I will assume same DB , different tables....

SQL = "select a., b. from hrTable a, leaveTable b where a.employee_no = b.employee_no and a.employee_no = " & request.form("empNo")

then just execute the SQL statement.

hth

bastien