sql select statement from two table

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

i have two table in sql server .country table and detail table.
detail table a country id more than 10.it means that detail table have 10 record
but i want to select only one record from detail table how it is done plz help me that will be greate help
thanks

Posted 26-Aug-11 21:55pm

joti parkash

Add a Solution

Comments

RaisKazi 27-Aug-11 3:59am

Question is unclear. Can you provide design of your both the tables?

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Ala'aldin Alzu'bi · Answer 1 · 2011-08-26T23:25:00

It is not clear from the problem description if the 10 records of "details" table are related to the same country (entry), or related to all countries (entries).

If the details are for different countries, then you need to use INNER JOIN statement to select each country with its details, but if the 10 details are related to the same country then you have two options:

1. The details are identified, then you can use WHERE statement.
2. The details are not identified and WHERE statement is not applicable. In this case you need to check you database design or unnecessary data redundancy.

Abhinav S · Answer 2 · 2011-08-26T22:10:00

Solution 2

You can always just do a LEFT JOIN on the two tables and select the TOP row.

Posted 26-Aug-11 22:10pm

Abhinav S

OriginalGriff · Answer 3 · 2011-08-26T22:00:00

Solution 1

It's difficult to be precise from your description, but have a look at the WHERE clause of the SQL SELECT statement: W3Schools[^]

SQL

SELECT * FROM myTable WHERE country='India'

Posted 26-Aug-11 22:00pm

OriginalGriff