Hardik Bhavsar

Hardik Bhavsar

  • NA
  • 164
  • 54.9k

How to find Record Compare to Month Product?

Nov 25 2013 12:26 AM
How to create a query when i give the month name same as product record display in amount otherwise not match product are not display in record?

EXAMPLE :-
Product Name Month   Amount

ABCD 5 20000
XYZ 5 10000
Kapchi  5 4500
RETI 5 65000
Jab Tak Hai Jaan 5 30000
Jab Tak Hai Jaan 6 30000
ABCD 6 20000
XYZ 6 10000
Kapchi  7 1000
RETI 7 45000
ABCD 8 20000
XYZ 8 10000
RETI 8 45000
Jab Tak Hai Jaan 8 30000
Kapchi  9 1000

GIVE OUTPUT :-
Product Name Month   Amount
Kapchi  5 4500
RETI 5 65000
Kapchi  7 1000
RETI 7 45000
RETI 8 45000
Kapchi  9 1000

Answers (7)