BEGINNERS SQL QUESTION

From: davout <davout_at_dial.pipex.com>
Date: Thu, 4 Mar 1999 08:11:54 -0000
Message-ID: <7blf7l$4e3$1@plug.news.pipex.net>

I have two tables....

    MyTran

---

    TranUID INTEGER
    TranName VARCHAR

    MyTranStatus

---

    TranUID INTEGER
    EntryDate DATE
    Status INTEGER

The data is something like....

    MyTran

---

    TranUID            TranName
        1                    Trans#1
        2                    Trans#2

    MyTranStatus

---

        TranUID        EntryDate        Status
            1                    23/1/99            6
            1                    2/2/99               7
            1                    10/2/99            5
            2                    31/1/99            6
            2                    28/2/99            4

How can I create a query whereby I can get all the records back from 'MyTran' with the most recent entry from the related MyTranStatus table? Like...

        1                    Trans#1        10/2/99    5
        2                    Trans#2        28/2/99    4

Any ideas? Received on Thu Mar 04 1999 - 02:11:54 CST