Connecting a Form with two diffrent table in SQL

Question

3.00/5 (1 vote)

See more:

Dear all i am trying to create a software for a book tread company...
But the problem is i am not able to connect to fatch the data from two table in sql....
format is like this ... book ISBN Is the primary key.
in one table i have isbn , book name , price.
and the another table i have isbn , creator of isbn.....

the componey requirement is in one form they want to know which isbn,title is created by whom. so on the bases of isbn i have to fatch data from two diffrent table of sql and in windows form show in a single form like 1.ISBN, 2.TITLE, 3.PRICE, 4.CREATE BY.

Dear friend please ignore the English Mistake and pleae help me to create this page .......

thanks in advance....

Posted 28-Jul-11 22:48pm

Nand Kishor Upadhyay

Add a Solution

1 solution

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)

nishadamit90 · Answer 1 · 2011-07-28T23:04:00

To fetch the data from two different tables You can use the join queries:

If first table name: first and second table name: second

SELECT first.isbn, first.bookName, first.price, second.creator
FROM first
INNER JOIN second
ON first.isbn=second.isbn

If not satisfied please clear your question again.