Member Avatar for moinbloch 
for example
i have table tbl_account
i have 5 account ac_no actully 5 accounts in table
i gate credit of that accout monthly


id  ac_no   name  credit  date

2     2      bbb   200     20-01-2015
3     3       ccc  200     25-01-2015
4     4      ddd   200     1-01-2015
5     5      eee   200     2-01-2015

6     1      aaa   200     1-02-2015
7     2      bbb   200     20-02-2015
8     3      ccc   200     25-02-2015 

i want query to fetch ac_no 4,5 detail who cant credit in 02 month
in same table..

Inline Code Example Here

  • 2 Contributors
  • 1 Reply
  • 71 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by djjeavons
Member Avatar for djjeavons

Hi

What do you mean by:

i want query to fetch ac_no 4,5 detail who cant credit in 02 month
in same table..

What SQL statements have you tried? What are the rules?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.