RSS Forums RSS
Please support our Oracle advertiser: Programming Forums

complicated

•
•
Join Date: Feb 2007
Location: London
Posts: 114
Reputation: davidcairns is an unknown quantity at this point 
Rep Power: 2
Solved Threads: 8
davidcairns davidcairns is offline Offline
Junior Poster

Re: complicated

  #2  
Apr 27th, 2007
Without answering your whole question I'll give you a start

You need 3 of the tables to find cost per hire -
HireContract
Staff
Branch

Join them to each other and you should then be able to find the contracts for each branch (join fields are StaffID and BranchNo)

Give it a go and post here when your done

Cheers

D
Reply With Quote  
Forums | Blogs | Tutorials | Code Snippets | Whitepapers | RSS Feeds | Advertising
All times are GMT -4. The time now is 12:28 am.
Newsletter Archive - Sitemap - Privacy Statement - Acceptable Use Policy - Contact Us
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC