---- matter listing by billing timekeeper - not summarized ---- SELECT mbillaty, tkfirst, tklast, mmatter, clname1, mdesc1, mloc, mhper, mhdobidb, mhdocodc, mhcrdc FROM son_db.dbo.matths, son_db.dbo.timekeep ttk, son_db.dbo.matter, son_db.dbo.client, son_db.dbo.periodt WHERE mhmatter = matter.mmatter and mclient = client.clnum and mbillaty = tkinit and mhper = pe and pebedt between '01/01/2004' and '12/31/2004'