I have two tables to collect data from while running a report. The report is design on the History table and it needs to get data also from the loan_history table based on two fields it should compare; the empid and the MonthYear. But when running the report. How can i get data from the loan_history table when both the empid and the MonthYear is the same?
for example
select loan_history.monthly_deductions from loan_history, History where history.empid = loan_history.empid and history.MonthYear= loan_history.MonthYear;
If it was in mysql..
thanks
0
Comments
Does that get you started?
My Blog - nav.education