locked
need a query for access tables RRS feed

  • Question

  • Hi

    I need a query , help please:

    table1:

    id              description                  serial                    

    1                des1                           ser1

    2                des2                           ser2

    3                des3                           ser3

    --------------------

    table2:

    id            id1(id of table1)                date                 stat

    1              1                                       2001                 A

    2              1                                       2008                 N

    3              2                                       2010                 A

    4              1                                       2012                 F

    ==============

    i need this data structure: (stat column must return for maximum date of id1 from table2)

    id(from table1)            serial(from table1)                  stat(from table2)

    1                                    ser1                                        2012

    2                                    ser2                                        2010

    3                                    ser3                                         Null

    Sunday, November 9, 2014 7:04 AM

Answers

All replies