What is the correct way to write an sql query like this?
"select * from MyTable where username ='username' And password ='Password'" in vb.net.
My problem is that on my database I have some usernames repeated but they differ by their passwords. Each record has a different information. When I tried this it will just return the wrong data especially if the intended record is not in the first same username record, it will just retrieve the first same username records, but I want to force it to only retrieve all data on the record where username and password match.