posted 16 years ago
(almost) Impossible in a plain sql query.
You would need to know upfront that t2 has exactly 24 rows for each t1 record,
then join in table t2 24 times,
meanwhile taking care that you don't join the same t2 record more than once.
Regards, Jan
OCUP UML fundamental and ITIL foundation