PROTECTED]]
Sent: Tuesday, 9 July 2002 05:37
To: 'Miles Roper'; '[EMAIL PROTECTED]'
Subject: RE: UDF, Can anyone please help?
So if below is actually what your data looks like, what about:
Select Field1, Field2, MAX(IDField) From MyTable Group by Field1
That might get the correct answer for you
Roper
Subject: RE: UDF, Can anyone please help?
Hi Miles,
Then I think that the easiest way is to create a
temporary table from this query:
Create Temporary Table TempTable Select Max(IDField)
From TheTable Group by Field1;
Then your inner join the temporary table with yours:
Select t1.* from
Hi Miles,
Could you explain the same thing with a some sample
data? I does not need to be your data. I think that
what you want to do is this but I am not sure.
Field1 Field2
A 1
A 1
A 2
A 3
B 1
B 1
B 2
C 2
C 2
C 4
C 4
When you say last
PROTECTED]'
Subject: Re: UDF, Can anyone please help?
Hi Miles,
Could you explain the same thing with a some sample
data? I does not need to be your data. I think that
what you want to do is this but I am not sure.
Field1 Field2
A 1
A 1
A 2
A 3
B 1
B 1
B 2
C 2
C
So if below is actually what your data looks like, what about:
Select Field1, Field2, MAX(IDField) From MyTable Group by Field1
That might get the correct answer for you, but it does however have an extra
field in the result (which may or may not be a problem).
cheers,
noel
filter word:mysql
Hi,
I've being trying for the last couple of months to convert a MS Access to
Mysql. I pull out data extract from around 100 + queries. These took about
5 months of solid work to develop and are extremely complex. I can convert
these to mysql, but have one big problem. There is no last