Hi,
I have two files A (master) & B (detail). And there is one common field vendor code in both file which are selected as left outer join. From detail file B I want to select always first record only. If record is available more then one then the amount is multiplying by no of records available in detail B.
Then I put condition select record sq# = 1 then its works fine till now every thing is OK.
Incase record is not available in B then report is blank.
Appreciate your valuable comments/solution.
I want to show the total amount from A and Vendor details from B.
Thanks in advance.