Home Forums SQL Server 7,2000 T-SQL Using IF in a SELECT statement? RE: Using IF in a SELECT statement?
mworku
Ten Centuries
Points: 1311
More actions
June 19, 2003 at 11:25 am
#462211
Select a.account_id, a.bill_contact, a.bill_address, cc.cc_number, cc.cc_type, cc.cc_exp
From Account a, (Select *
From Credit_Card) As cc
Where (a.bill_method = 'CC' AND
a.account_id = cc.account_id)
MW