I have two sql tables tblPatient and tblHousehold which have duplicate records in them. The tables are linked by a field lngHouseid.
I need to write a program to query the databases and display on the form the duplicates retuned for that person.
I am new to vb.net so I'm having a problem getting started. I wrote a query in sql which returns the records but when I try to put that sql in a sql adapter it gives me an error.
So far I have a sql connection which is working, but I cannot get my sql adapter to work. Also If I am successful if pull the records I'm not sure how to group them to display on a page by name.