Sort data based on sort from another table

I have a table whose data I would like to sort based on the sorting of
another table.

In one table I have a column of IDs. There is also a column of dates
used to sort the data by the date on which it was recorded.

In another table I have a column of the same IDs (but not necessarily
all of them or in the same order), as well as some other data recorded
at another time.

I would like to sort the data in this second table in the order the
first table was sorted without having to create another column with the
same date entries as the first table. In other words, sort the data in
the second table by the order of IDs in the first. Any ideas?

Thanks!

.

Relevant Pages

  • RE: Bug? When I open my file, the tasks are renumbered and out of
    ... "Kevin" wrote: ... also point out, that while some IDs and information is still there, certain ... Might I suggest examination of the WBS numbering since you may want to sort ... about Microsoft Project ...
    (microsoft.public.project)
  • RE: Bug? When I open my file, the tasks are renumbered and out of
    ... about Microsoft Project ... "Kevin" wrote: ... also point out, that while some IDs and information is still there, certain ... Might I suggest examination of the WBS numbering since you may want to sort ...
    (microsoft.public.project)
  • Sorting entries in a DBM hash by one of the variables
    ... I have a slight problem in that I want to list all the entries in a ... DBM file. ... I'm fine with sorting my the key, but I want to sort by one ...
    (comp.lang.perl)
  • RE: Bug? When I open my file, the tasks are renumbered and out of
    ... also point out, that while some IDs and information is still there, certain ... Might I suggest examination of the WBS numbering since you may want to sort ... Visit http://project.mvps.org/ for FAQs and more information ... about Microsoft Project ...
    (microsoft.public.project)
  • Re: changing default justification
    ... sort, and be used against selection criteria) right justified. ... I hope you don't need to index on the ID, as most of the time, item-IDs ... the IDs, then I disagree that you need to pad leading zeroes: ...
    (comp.databases.pick)