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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
