Show Bid Request
SQL Help
Bid Request Id: 72617
|
|
|
|
Posted by: |
MCD (6 ratings)
(Software buyer rating 10 )
|
|
Non-action Ratio: |
Above Average - 27.27%
|
Buyer Security Verifications: |
Unverified
|
|
Approved on: |
Jul 11, 2003
11:08:33 AM EDT
|
|
Bidding Closes: |
Jul 14, 2003
11:07:35 AM EDT
|
|
Viewed (by coders): |
83 times
|
|
Deadline: |
7/12/2003 1:25:31 PM
(1 days after 7/11/2003 1:25:31 PM)
|
|
|
|
|
Description:
We need some SQL help for the following two tables
Table one Organization
Field: OrganizationID
Field: Name
Example Data:
1 Dayton
2 Florida
3 Ohio
Table 2: OrganizationHucs
Field: OrganizationID
Field: HUC_ID
Example Data
1 2
1 3
1 5
2 3
2 5
We need an SQL that will return a list of organization that have or contain their OrgainzationID with in the OrganizationHUCs table for a specific HUC_ID
So if I say I want all the organizations that have a "3" Huc_ID in the OrganizationHUCs table then it would return from the Organization Table: Dayton and Florida
Deliverables:
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.
3) Complete ownership and distribution copyrights to all work purchased.
Platform:
ASP SQL 2000 server
Remember that contacting the other party outside of the site (by email, phone, etc.) on all business projects < $500 (before the buyer's money is escrowed) is a violation of both the software buyer and seller agreements.
We monitor all site activity for such violations and can instantly expel transgressers on the spot, so we thank you in advance for your cooperation.
If you notice a violation please help out the site and report it. Thanks for your help.
|
|
|
Bidding/Comments:
|
All monetary amounts on the site are in United States dollars.
Rent a Coder is a closed auction, so coders can only see their own bids and comments. Buyers can view every posting made on their bid requests. |
See all rejected bids (and all comments)
| Name |
Bid Amount
|
Date |
Coder Rating |
|
|
|
This bid was accepted by the buyer!
|
$5 (USD)
|
Jul 11, 2003
11:20:47 AM EDT
|
10
(Excellent)
|
|
|
please check my resume at http://www.pursca.com/johnleeresume.aspx?id=sqlhelp
I can help you on any issue related to SQL - not just statement, performance tuning, ...
here is the SQL statement you need:
(use sub-query)
SELECT OrganizationID, Name
FROM Organization
WHERE OrganizationID IN (SELECT OrganizationID FROM OrganizationHucs WHERE HUC_ID = 3)
or
(use join)
SELECT o.OrganizationID, o.Name
FROM Organization o INNER JOIN
OrganizationHucs oh ON o.OrganizationID = oh.OrganizationID
WHERE oh.HUC_ID = 3
Regards,
John Lee
If Quality matters to you, then I am the ONE. |
|
|
|
|
|
|