hi guys just wondering if this sql statement is correct, im trying to delete records from 2 tables from a database. The user types in the name they wish to delete in the text box and then they hit the button, in the button event code i have the following sql statement,
Dim myselectQuery As String = "DELETE * FROM admin and users where username = '" & TextBox1.Text & "' "
my program is implemented using vb
.net and the database is on a sqlserver, many thanks in advance. oh by the way both the admin table and the user table have a primary key as username.