How can I build my SQL query from these tables?
- by vee
Hi All,
I'm thinking of building query from these 2 tables (on SQL Server 2008). I have 2 tables as shown below:
Table 1
MemberId . MemberName . Percentage . Amount1
00000001 AAA 1.0 100
00000002 BBB 1.2 800
00000003 ZZZ 1.0 700
Table 2
MemberId . MemberName . …