Query of changes to parent or child
Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance
I have a parent table with 3 children tables. Each of the child
records has an activity date on it to represent a change to the
record.
The client wants a query where any parent record where 1 or more of
the children have an activity date within the date parameters would be
included.
I was hoping for some pointers on the most efficient way to do this.
Thanks!
Jeff
.
Relevant Pages
- Unix Programming FAQ (v1.37)
... Why use _exit rather than exit in the child branch of a fork? ... Why doesn't my process get SIGHUP when its parent dies? ... How do I create a named pipe? ... How do I compare strings using regular expressions? ... (comp.unix.programmer) - Unix Programming FAQ (v1.37)
... Why use _exit rather than exit in the child branch of a fork? ... Why doesn't my process get SIGHUP when its parent dies? ... How do I create a named pipe? ... How do I compare strings using regular expressions? ... (comp.unix.programmer) - Unix Programming FAQ (v1.37)
... Why use _exit rather than exit in the child branch of a fork? ... Why doesn't my process get SIGHUP when its parent dies? ... How do I create a named pipe? ... How do I compare strings using regular expressions? ... (comp.unix.programmer) - Unix Programming FAQ (v1.37)
... Why use _exit rather than exit in the child branch of a fork? ... Why doesn't my process get SIGHUP when its parent dies? ... How do I create a named pipe? ... How do I compare strings using regular expressions? ... (comp.unix.programmer) - Unix Programming FAQ (v1.37)
... Why use _exit rather than exit in the child branch of a fork? ... Why doesn't my process get SIGHUP when its parent dies? ... How do I create a named pipe? ... How do I compare strings using regular expressions? ... (comp.unix.programmer) |
|