Skip to content

Searcharticlesvideosblogsforumsinterview questionsarticles

Tech
Articles
Blogs
News
Videos
Interviews
Forums
Books
Events
- Jobs
- Stories

Article
Blog
Video
Ebook
Interview Question

Loading

Upcoming Events

23 NOV
AI Agents Conference 2026 - 3rd Edition

Our Training Programs

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

©2026 C# Corner.

All contents are copyright of their authors.

compare two tables select distinct field

Home
Forums
Visual Basic .NET

compare two tables select distinct field

VINAY KUMAR

9yAsked Mar 15, 2017, 7:46 AM819Visual Basic .NET

i have table like below

table_a

sno name student_id

1 abcd 1

2 bcad 2

table_b

sno student_id amount

1 1 600

2 1 500

3 2 200

compare twotables addition amount field and select name field

i want like below format

Student_id name totalamount

1 abcd 1100

2 bcad 700

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sign in to answer this question

It is the same account you read, post and publish with — and you will come straight back to this page.

Sign in Create an account

Ramesh Palanivel9y ago
Accepted answer
Hi VinayKumar,

Sorry I missed some line in that,
select table_a.Student_id,table_a.name,sum(table_b.amount) from table_a left outer join
table_b on table_a.Student_id=table_b.student_id group by table_a.Student_id
Kindly try this code
VINAY KUMAR9y ago
1. select table_a.Student_id,table_a.name,sum(table_b.amount) from table_a left outer join
2. table_b on table_a.Student_id=table_b.student_id group by table_a.Student_id
above code i want search single record only

above code is work all records ......how to use where condition

ex:-

tablename where id="232"
VINAY KUMAR9y ago
hi
it shows error like......

Incorrect syntax near the keyword 'group'
Ramesh Palanivel9y ago
Hi VinayKumar,

Try this code,
select table_a.Student_id,table_a.name,sum(table_b.amount) from table_a left outer join table_b group by table_a.Student_id