 |  |  |  |  |  |  |  |
Joins
Please support our MS SQL advertiser: Intel Parallel Studio Home
 |
•
•
Join Date: Sep 2007
Posts: 14
Reputation: 
Solved Threads: 1
Newbie Poster
Hi
can any one help me in following case?
Table A
ID | Name
1 , Apple
2 , Bat
3 , Cat
4 , Dog
Table B
ID | Name
1 , A
2 , B
3 , C
4 , D
5 , E
6 , F
7 , G
How will i get the below result??
Results
ID | Name
1 , Apple
2 , Bat
3 , Cat
4 , Dog
5 , E
6 , F
7 , G
How can I achieve this.
Thanks
can any one help me in following case?
Table A
ID | Name
1 , Apple
2 , Bat
3 , Cat
4 , Dog
Table B
ID | Name
1 , A
2 , B
3 , C
4 , D
5 , E
6 , F
7 , G
How will i get the below result??
Results
ID | Name
1 , Apple
2 , Bat
3 , Cat
4 , Dog
5 , E
6 , F
7 , G
How can I achieve this.
Thanks
•
•
Join Date: Jul 2005
Posts: 483
Reputation:
Solved Threads: 19
Posting Pro in Training
ok, i am assuming that you want a name for all id's. if a has an entry use that, otherwise use the name from b. also assuming that B has an entry for every id. if those assumptions are correct, then this should work
MS SQL Syntax (Toggle Plain Text)
•
•
Join Date: Feb 2005
Posts: 1,181
Reputation:
Solved Threads: 67
Or maybe:
MS SQL Syntax (Toggle Plain Text)
•
•
Join Date: Jul 2005
Posts: 483
Reputation:
Solved Threads: 19
Posting Pro in Training
that would add the assumption that the names in b are the first letter of the names in a
•
•
Join Date: Feb 2005
Posts: 1,181
Reputation:
Solved Threads: 67
Hmm not really, it replaces the assumption that a.id is a foreign key to b.id.
The OP does not specify. If there is a relation between the id's (which there should be in my opinion, and if the data provided represents all possibilities, then this is indeed the case) your solution is the more efficient.
However if the id's are not related then that only leaves the initial letters, in which case my alternate solution will do.
The OP does not specify. If there is a relation between the id's (which there should be in my opinion, and if the data provided represents all possibilities, then this is indeed the case) your solution is the more efficient.
However if the id's are not related then that only leaves the initial letters, in which case my alternate solution will do.
•
•
Join Date: Sep 2007
Posts: 14
Reputation:
Solved Threads: 1
Newbie Poster
•
•
•
•
Originally Posted by campkev 
ok, i am assuming that you want a name for all id's. if a has an entry use that, otherwise use the name from b. also assuming that B has an entry for every id. if those assumptions are correct, then this should work
MS SQL Syntax (Toggle Plain Text)
Thanks to reply my query. It worked.
Last edited by bhakti.thakkar; Jan 28th, 2008 at 12:36 am.
|
Similar Threads
- Mysql Joins Assistance (MySQL)
- Wordpress, Joins and Indexes (MySQL)
- Sql Joins (MySQL)
- MS SQL Joins - newb assistance (MS SQL)
- Joins (MySQL)
- Problem with Rewriting Subqueries as Joins (Database Design)
- Problem with Rewriting Subqueries as Joins (MS SQL)
Other Threads in the MS SQL Forum
- Previous Thread: StoredProcedure @variable = table.field not working
- Next Thread: Wierd maintenance plan problem
| Thread Tools | Search this Thread |
Latest MS SQL Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
Tag cloud for MS SQL
"last autogrowth business connectingtodatabaseinuse count cursor data database dateadd datepart day" dbsize deadlock delete_trigger getdate highperformancecomputing hpc hpcserver2008 ibm iis loop maximum microsoft ms mssql multiple multithreading news number permission query reporting result server services sets source sql sqlserver sqlserver2005 supercomputing tables uniqueid update view weekday
