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.

hi there..

as far as i know, you can't do a delete statment like that.. you have to delete from one table and from the other in 2 diferents sql...

HTH

Gonzalo

DELETE * FROM admin and users where username = '" & TextBox1.Text & "' "

you can only perform a delete statement on one table. also your above code is not correct.
try: DELETE FROM admin and users where username = '" & TextBox1.Text & "' "
notice the asterisk mark is removed.