select type from [User] where username = 'the_username_wanted'
SELECT * FROM Admin a JOIN User u ON a.username = u.username WHERE a.username = @username AND a.password = @password
select type from user where username = @username
select type from UserT inner join Admin on UserT.UserId=Admin.UserId where UserT.UserName='xyz'
SELECT type FROM Admin a INNER JOIN User u ON a.username = u.username WHERE a.username = @username AND a.password = @password
select type from user u, admin a where a.username=b.username and a.username='demo' and a.password='demo'
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)