I have two tables, one is Employeebill table, another is EmployeePay table, in Employeebill table has two rows for the month of August and September Salary, and in Employeepay table has one rows for the September salary(that was as advance). Now I want to show in my crystal report for the payable salary. note: September salary has paid as advance. So payable salary will be from Employeebill table for August salary. But when I make inner join I got for one rows with september salary, and when I make outer join I got for two rows with september and August Salary, But I want to show only one rows for August salary.
Have anyone able to help in this regards. I will gratefull for ever.
Regards
Shah Noman
Software Engineer.
Callsnit Inc.