I need to sample code of query which compare two table

Question

0.00/5 (No votes)

See more:

VB

I need to select some information from member table where member field =familymember field

Posted 23-Mar-10 21:15pm

vipin.sethumadhavan

Add a Solution

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

Christian Graus · Answer 1 · 2010-03-23T21:16:00

What do you mean by table ? If you mean a database table, I would suggest that this is precisely the sort of trivial, simple, idiot proof task that you should do some research on and use as an opportunity to learn at least the basics of database development.

I assume you wanted precisely this sort of advice and not code you could copy and paste, because otherwise you'd have told us the schema of your tables and the other information required to write this code.

md1006 · Answer 2 · 2010-03-23T21:18:00

Solution 2

Hello,
Plz, elaborate your question a bit.

Posted 23-Mar-10 21:18pm

md1006

md1006 · Answer 3 · 2010-03-23T21:26:00

Solution 3

Hello,

You may try similar code according to your requirement:

SELECT *
FROM employee, department
WHERE employee.DepartmentID = department.DepartmentID

Hope this will be helpful.

Posted 23-Mar-10 21:26pm

md1006

Sagar Khairnar 55 · Answer 4 · 2010-03-23T21:35:00

Solution 4

Hello

u should first learn the basic thing.
if ur qus is releated to database then i suggest u to first study the basic
and not just make the copy, paste habit

Posted 23-Mar-10 21:35pm

Sagar Khairnar 55