Link to home
Start Free TrialLog in
Avatar of lbseong
lbseong

asked on

SQL comparision probelm?

I have to select the database dta to compare with other maskedit box..if the data from the table is use by other user then i cant delete the maskedit data..
eg..
table:
name   user
aa     test
bb     test1
cc     test2
dd
ee

if i want to delete aa,i cant delete it cause it is use by test, but if i want to delete dd,ee, i can cause it didnt use by other..
so how to do the caompare and do the delete thing..the sql command..and also the procedure pls..thanks.
ASKER CERTIFIED SOLUTION
Avatar of Jason Sweby
Jason Sweby
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of CleanupPing
CleanupPing

lbseong:
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
EXPERTS:
Post your closing recommendations!  No comment means you don't care.
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

accept jsweby's comment as answer

Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

Thanks,

geobul
EE Cleanup Volunteer