List:General Discussion« Previous MessageNext Message »
From:Peter Brawley Date:October 7 2005 7:28pm
Subject:Re: Joining tables, duplicating none
View as plain text  
Jonathan,

 >I have two tables with date and uid cols. in common.
 >Table 1 has one row per date, Table 2 has a maximum
 >of 7 rows per date.

 >select t1.date, t1.val, t2.val from t1
 >right join t2 on t1.date = t2.date
 >where t1.date between '2005-08-01' and '2005-08-14'
 >and t1.uid = 'me';

A right join returns rows from t2 whether or not there are matches in 
t1. Is that what you want?

For examples of turning query result rows into columns see
   pivot table schedule
   pivot table using join
   rows into columns
at http://www.artfulsoftware.com/queries.php. 

PB

-----

Jonathan Mangin wrote:

> I have two tables with date and uid cols. in common.
> Table 1 has one row per date, Table 2 has a maximum
> of 7 rows per date.
>
> select t1.date, t1.val, t2.val from t1
> right join t2 on t1.date = t2.date
> where t1.date between '2005-08-01' and '2005-08-14'
> and t1.uid = 'me';
>
> +------------------------------+
> | t1.date    | t1.val | t2.val |
> +------------+--------+--------+
> | 2005-08-01 |     92 |   18.3 |
> | 2005-08-01 |     92 |   23.3 |
> +------------+--------+--------+
>
> Is there any way to get something like this
>
> +------------------------------+--------+
> | t1.date    | t1.val | t2.val | t2.val |
> +------------+--------+--------+--------+
> | 2005-08-01 |     92 |   18.3 |   23.3 |
> +------------+--------+--------+--------+
>
> instead of duplicating Table 1 rows for every row
> in Table 2?
>
> Thanks,
> Jon
>
>


-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.11.13/123 - Release Date: 10/6/2005

Thread
Joining tables, duplicating noneJonathan Mangin7 Oct
  • Re: Joining tables, duplicating noneSGreen7 Oct
    • Re: Joining tables, duplicating noneJonathan Mangin7 Oct
      • Re: Joining tables, duplicating noneSGreen7 Oct
  • Re: Joining tables, duplicating nonePeter Brawley7 Oct
  • Re: Joining tables, duplicating noneGleb Paharenko8 Oct
  • Re: Joining tables, duplicating noneJoerg Bruehe10 Oct