List:General Discussion« Previous MessageNext Message »
From:Michael Stroh Date:June 3 2010 3:54pm
Subject:Re: Help needed on query on multiple tables
View as plain text  
Thanks! That did it perfectly!

Michael


On Jun 3, 2010, at 11:45 AM, Steven Staples wrote:

> How about this?
> 
> SELECT
>        `first_table`.`names`
>        , `first_table`.`version`
>        , (SELECT
>                   COUNT(`other_table`.`names`)
>           FROM `other_table`
>           WHERE `other_table`.`this_id` = `first_table`.`id`) AS 'count'
> FROM `first_table`
> WHERE `first_table`.`progress` > 0;
> 
> 
> Granted, you have not provided structure or names of the tables so this is
> just my interpretation, but maybe something like this could give you a
> starting point?
> 
> Steven Staples
> 
> 
>> -----Original Message-----
>> From: Michael Stroh [mailto:stroh@stripped]
>> Sent: June 3, 2010 11:24 AM
>> To: MySql
>> Subject: Help needed on query on multiple tables
>> 
>> Hi everyone. I'm trying to create a certain MySQL query but I'm not sure
>> how to do it. Here is a stripped down version of the result I'm aiming
> for.
>> I'm pretty new to queries that act on multiple tables, so apologize if
> this
>> is a very stupid question.
>> 
>> I have one table (data) that has two columns (names and progress). I have
> a
>> second table (items) that has two columns (names and version). I'd like to
>> do a query that produces the name of every record in data that has
> progress
>> set to 0 and the number of records in the items table that have the same
>> value in each table.names field.
>> 
>> I can perform this by using two sets of queries, one that queries the data
>> table and then loop through the names to do a count(names) query, but I'm
>> not sure if I can somehow do it in one query.
>> 
>> Thanks in advance!
>> Michael
>> 
>> 
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>> 
>> No virus found in this incoming message.
>> Checked by AVG - www.avg.com
>> Version: 9.0.829 / Virus Database: 271.1.1/2895 - Release Date: 06/03/10
>> 02:25:00
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
> 

Thread
Help needed on query on multiple tablesMichael Stroh3 Jun
  • RE: Help needed on query on multiple tablesSteven Staples3 Jun
    • Re: Help needed on query on multiple tablesMichael Stroh3 Jun
      • RE: Help needed on query on multiple tablesSteven Staples3 Jun