Need help with a query please.

Last Post 06 Oct 2004 03:59 AM by Gazzoid. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
Gazzoid
New Member
New Member

--
06 Oct 2004 03:59 AM
Hi, I have the following problem. I have two tables, one containing a timesheet header, i.e. timesheet number, name etc and the other containing 8 rows of rates for the header. I need to create a query that returns just one row containing the the header and each of the 8 rates for example

table 1
=====
Ts ID 2 Header

table 2
=====
Ts ID 2 Rate 1
Ts ID 2 Rate 2
Ts ID 2 Rate 3
Ts ID 2 Rate 4
Ts ID 2 Rate 5
Ts ID 2 Rate 6
Ts ID 2 Rate 7
Ts ID 2 Rate 8

would return

TS ID 2, Rate1, Rate 2, Rate 3,Rate 4,Rate 5,Rate 6,Rate 7, Rate 8

any help appreciated

Regards

Gary


Acceptable Use Policy
---