Home Forums SQL Server 7,2000 T-SQL Using IF in a SELECT statement? RE: Using IF in a SELECT statement?

  • 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


    MW