how to connect two tables and match the same value and display

Question

1.00/5 (1 vote)

See more:

i have two tables registration in which username is one column and second i have result as my table and total as my column.as soon i register myself it gets stored in registration table and some value when i run the application ,that gets stored in result table.when the username is stored ,simultaneoussly the total column is stored in result table.

now i want to display the result of the entered username.

if i enter the username the particular value of that user should match with that particular row in result table.once i find the row of the username that should match with the row of result table.
what query i need to use.

is it some outer join.
plz give me the query.

Posted 22-Nov-11 20:48pm

Member 8388026

Add a Solution

2 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)

Prasad_Kulkarni · Answer 1 · 2011-11-23T22:35:00

Solution 3

SQL

SELECT * from result
FULL OUTER JOIN  registration
ON registration.ID = result.registrationID 
WHERE registration.username='"+TextBox1.Text+"'

Posted 23-Nov-11 22:35pm

Prasad_Kulkarni

Updated 24-Nov-11 0:21am

v4

Prince Antony G · Answer 2 · 2011-11-24T00:13:00

Solution 4

U have to maintain the "userid" column in both table.

SQL

select * from registation t1,result t2 where t1.username='"+TextBox1.Text+"'  and t1.userid=t2.userid

Posted 24-Nov-11 0:13am

Prince Antony G

Updated 24-Nov-11 0:28am

v2