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