Re: Access to MySQL query problem
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]
Re: Access to MySQL query problem
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]
Re: Access to MySQL query problem
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 OpUser > 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]
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 OpUser 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
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 OpUser 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]
