When I import the timetracking table the rate column imports empty - how do I get the correct rates to come over with the table?

See: How do I insert data into the Timetracking table? 

The "Rate" column is empty because it actually comes from the ItemServiceRefFullName used.

The Rate column is not queryable or insertable, so you won't see any values in the TimeTracking table. While it's updateable, when I tried:

Update TimeTracking set rate = 50 where TxnID = '655-933357513'

QuickBooks said:

SQL Statement: Update TimeTracking set rate = 50 where TxnID = '655-933357513'
530 - The field "Rate" is not supported by this implementation.

At one time I tried to use lookup tables which did insert the correct rates and the syntax is similar to your set rate statement. Is there any way to relate a set of tables to get the rates?

Actually I've covered all of this in: Table Relations for TimeByName and TimeTracking 

But for normal Salary Employees, try this instead:

Select timetracking.txndate, timetracking.entityreflistid, timetracking.durationminutes,
timetracking.payrollitemwagereffullname, timetracking.payrollitemwagereflistid,
EmployeeEarning.PayrollInfoEarningsRate, timetracking.notes
from timetracking, EmployeeEarning
where timetracking.entityreflistid = EmployeeEarning.ListID
and timetracking.txndate >= {d '2008-12-01'} and timetracking.txndate <= {d '2008-12-31'}
and timetracking.payrollitemwagereflistid =
EmployeeEarning.PayrollInfoEarningsPayrollItemWageRefListID