General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Chad,
I did not get any errors with this code.
AND
IT WORKS!!!!!!!!!!
I thought it did not work at first because I saw the 1st query and it shows the CLOSED inmate. Then I closed that query and I guess the next one ran (I placed the code in a prg and ran it), and HELLO, there it is, the OPEN inmate.
Man, I sure do appreciate the help. You probably know this but this is a very powerful query. Why? That means anytime I need the latest child txn for a parent, I can get it. For tables in 3rd normal form this will be EXTREMLY helpful.
Thanks again to ALL for the help,
John
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only