Author: Nancy Folsom
Posted: 2004-05-24 at 14:56:37
Aj-
>I am using foxpro but its a SQL question anyway.
>
>Ive googled my a$$ off on the topic but cant seem to find an answer.
>I have a table with a few date columns for payment dates. I need to get
>the highest value out of this table and display it as a single column in
>my query. On top of that, each date row determines who paid the bill.
>An attorney a doctor etc. and mark the returned data as such ex
>"10/24/05 ATT".
>Anyone been down this road before.
Of course. But it's frustrating to try and guess what you need given
what you've said about the conditions so far. Anders Atberg, God of
SQL in the Fox world, always suggests people post an example of their
data and what they'd expect as a result set given a correct query.
Then we can help you fashion the query.
Show us in the style of the following what your structure is like
(leave off unrelated facts, please).
CREATE TABLE Payments (iID I, cPayee C(10), yPayment Y, dPaid D)
INSERT INTO Payees VALUES (1,'Terry',10.00, {^2004/05/24})
etc, etc.
Then, show us a result of what you want to see. Like
Payee Payment Date paid
----- ------- ---------
Terry 10.00 05/24/2004
And so on.
Regards-
Nancy Folsom
Pixel Dust Industries
Author _Debugging_Visual_FoxPro_Applications_