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]
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
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]
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]
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]