4
Reply

search only single record

VINAY KUMAR

VINAY KUMAR

Mar 15 2017 11:02 AM
245
  1. select table_a.Student_id,table_a.name,sum(table_b.amount) from table_a left outerjoin
  2. table_b on table_a.Student_id=table_b.student_id group by table_a.Student_id

above code
 
i want search only single record only
above code is work for all records ......
 
 
how to use where condition
ex:-
tablename where id="232"

Upload Source Code  Select only zip and rar file.
Answers (4)