compare two tables select distinct field

Question

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

Ramesh Palanivel · Answer

Hi VinayKumar Sorry I missed some line in that select table_a.Student_idtable_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 KUMAR · Answer

select table_a.Student_idtable_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 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 KUMAR · Answer

hi it shows error like...... Incorrect syntax near the keyword 'group'

Ramesh Palanivel · Answer

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