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]> 3/29/04 12:18:37 AM >>> 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 Access database to MySQL 4.1.1 and I need help with a > near impossible query. In the Access DB I used a stored procedure; I > think I should be able to solve this problem with a subselect in MySQL > but so far I'm not having any luck. > > Here's the problem; In my stored precedure query I get results that > look like this > > Item Op User > 2751 2 Dude > 2751 3 Aguy > 4785 1 Dude > 4785 2 Gus > 5623 1 Dude > 5623 2 Gus > 5654 1 Gus > 5654 2 Aguy > > I then query these results to get only the Items for a user when the > specified user is the first person for that Item ID, for example. If I > query the results for Dude Items 2751, 4785 & 5623 are returned. If I > query the results for Gus Item 5654 are return but not Items 4785 or > 5623. If I query the results for Aguy no Items are returned. > > Does anyone have any thoughts on this? > > Thanks > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]