P
Prabhat
Help need to get records from this Trans Table:
TransID CustomerName LicenseNo ProductID Price DtOfSale
1 Prabhat 0123456781 10 125
2 Prabhat 0123456782 20 123
3 Prabhat 0123456783 30 23
4 Prabhat 0123456784 10 234
5 Prabhat 0123456785 10 234
6 Raja 0123456786 10 234
7 Raja 0123456787 40 234
8 Raja 0123456788 30 345
9 Pramod 0123456789 40 234
10 Rajesh 0123456791 20 234
11 Rajesh 0123456792 30 2423
12 Aravinda 0123456793 10 123
13 Aravinda 0123456794 10 234
14 Aslam 0123456795 10 123
15 Sudheer 0123456796 20 123
16 Mohan 0123456797 30 1234
17 Mohan 0123456798 10 1234
18 Mohan 0123456790 10 234
19 Rakesh 0123456799 10 234
20 Susil 0123456711 20 234
21 Mohan 0123456712 40 123
-----------------------------------------------------------------------
How can I get the records with detals: "CustomerName, LicenseNo, DtOfSale"
those are having Multiple Copies (>1) of Product# 10 But Does not have
Product# 40.
Thanks
Prabhat
TransID CustomerName LicenseNo ProductID Price DtOfSale
1 Prabhat 0123456781 10 125
2 Prabhat 0123456782 20 123
3 Prabhat 0123456783 30 23
4 Prabhat 0123456784 10 234
5 Prabhat 0123456785 10 234
6 Raja 0123456786 10 234
7 Raja 0123456787 40 234
8 Raja 0123456788 30 345
9 Pramod 0123456789 40 234
10 Rajesh 0123456791 20 234
11 Rajesh 0123456792 30 2423
12 Aravinda 0123456793 10 123
13 Aravinda 0123456794 10 234
14 Aslam 0123456795 10 123
15 Sudheer 0123456796 20 123
16 Mohan 0123456797 30 1234
17 Mohan 0123456798 10 1234
18 Mohan 0123456790 10 234
19 Rakesh 0123456799 10 234
20 Susil 0123456711 20 234
21 Mohan 0123456712 40 123
-----------------------------------------------------------------------
How can I get the records with detals: "CustomerName, LicenseNo, DtOfSale"
those are having Multiple Copies (>1) of Product# 10 But Does not have
Product# 40.
Thanks
Prabhat