I have to concur, MS Access with ODBC linked tables is not a good solution when those
tables contain
large amounts of data.
I had queries run for hours and then come up with a simple "ODBC Failed" message at
the end of it.
Maybe Access has improved though.
Tod Harter wrote:
> Watch out wit
You're right, it wasn't the answer I wanted to hear ;-)
But it has a ring of truth to it.
Thanks for all your help
Mick
Paul DuBois wrote:
> At 13:34 +0100 4/19/02, Mick Watson wrote:
> >Thank you :-)
> >
> >I do realise the SQL is not being used as it
(), COUNT().
>
> If you need to know the internal machinations of mysql, I can only suggest
> that you study the source code.
> ----- Original Message -
> From: Mick Watson <[EMAIL PROTECTED]>
> To: Richard Emery <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
upposed to be used. Your
> SQL is in error, not mysql.
>
> hope this helps...
> - Original Message -
> From: Mick Watson <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Friday, April 19, 2002 6:01 AM
> Subject: group by help?
>
> Hi
>
>
Hi
I am having some trouble figuring out how mySQL interprets the group by
clause in a particular set of data that I have (the ensembl database if
anyone is familar with it!)
Now, I have some data like this:
+-++--+
| gene_id | display_id | db_name |
+-+
