, but I recommend picking up a good book on database
theory. :)
Regards,
Matthew Moldvan
System Administrator
Trilogy International, Inc.
-Original Message-
From: Sparky Kopetzky [mailto:[EMAIL PROTECTED]
Sent: Saturday, July 05, 2003 12:20 PM
To: PHP DB Group
Subject: [PHP-DB] Very
that help?
Ryan
-Original Message-
From: Matthew Moldvan [mailto:[EMAIL PROTECTED]
Sent: Monday, July 07, 2003 1:18 PM
To: 'Sparky Kopetzky'; PHP DB Group
Subject: RE: [PHP-DB] Very confused with query
Hi Robin,
I think you are not using DISTINCT correctly ... try SELECT DISTINCT
whatever
Good morning!!
I'm trying to select 1 and only one record from each user based on the last date from
a transaction file. This is what I'm using and it's not even close. It seems DISTINCT
does not work!!
SELECT DISCTINCT(transaction_user_id), MAX(transaction_date), * FROM transaction;
Could