I already specified the version, 4.1.1. My problem query is this,
SELECT Item
FROM StoredProc
GROUP BY Item
HAVING (First(User)="Gus");
my StoredProc query is a simple one,
SELECT Item, Op, User
FROM tblSource
ORDER BY Item, Op;
Any Thoughts?
Thanks
>>> "Nitin Mehta" <[EMAIL PROTECTED]
I already specified the version, 4.1.1. My problem query is this,
SELECT Item
FROM StoredProc
GROUP BY Item
HAVING (First(User)="Gus");
my StoredProc query is a simple one,
SELECT Item, Op, User
FROM tblSource
ORDER BY Item, Op;
Any Thoughts?
Thanks
>>> "Nitin Mehta" <[EMAIL PROTECTED]
please include the query, you are using with no success and also specify the
version of your mysql.
Nitin
- Original Message -
From: "Ed Reed" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, March 29, 2004 1:27 PM
Subject: Access to MySQL query problem
> I'm coverting an Acc
