My table structure is like below
TblMemberInfo | TblCarInfo
MemberID Name | Id MemberId CarNumber
1 Sandeep | 1 2 1234
2 Vishal | 2 1 1111
3 John | 3 4 2458
4 Kevin | 4 2 1296
5 Devid | 5 4 7878
| 6 3 4859
I need to query for select all from TblMemberInfo,TblCarInfo where Count(MemberId)=1
MemberId Name CarNumber
1 Sandeep 1111
3 John 4859
