sql - Proper way to return value -

sql - Proper way to return value -

i have situation want delete fellow member members table if , of fellow member has no transaction in members_transaction table.

i want know whether fellow member has transaction. homecoming column value of 1 indicate @ to the lowest degree 1 transaction exists member, or 0 indicate fellow member has no transaction , has been deleted upon execution of query. query follows:

if exists ( select members_trans_id members_transaction member_link_id = 188 ) select 1 else delete members member_link_id = 188; select 0

my concern 2 lines in else block. can execute query no problem @ sql server management studio, wonder if correct write way.

i'm using sql server 2008 r2.

thank you.

left joins friend , fast. view members , transactions:

select m.name, count(*) totaltransactions fellow member m left bring together members_transaction mt on mt.member_link_id=m.member_link_id mt.member_link_id null grouping m.name order m.name

(to find ones no transactions, add together having count(*)=0 end)

to zap freeloaders:

delete m fellow member m left bring together members_transaction mt on mt.member_link_id=m.member_link_id mt.member_link_id null

i'm assuming want members. single 1 add together id in clauses.

sql sql-server