what is wrong with this

[Machlink]

SELECT ACCT_NO,
(SELECT SUM(tran_record.amount)
FROM tran_record
WHERE tran_record.acct_no = T1.acct_no) AS balance,
(SELECT SUM(tran_record.amount)
FROM tran_record
WHERE tran_record.acct_no = T1.acct_no
((SELECT bill_master.alt_bill_group
FROM bill_master B1
WHERE B1.bill_code = tran_record.bill_code) AS bill_group) AS TV_amt
FROM dbo.ACCT_MASTER T1
WHERE (ACCT_NO = '431101590001')

 

[mbiro]

You are missing a )

 

[hneal98]

No, you have one too many (

 

[Machlink]

Iam getting error in where clause near As

can someone fix for me this statement

 

[hneal98]

SELECT ACCT_NO,
       (SELECT SUM(tran_record.amount)
        FROM   tran_record
        WHERE  tran_record.acct_no = T1.acct_no) AS balance,
       (SELECT SUM(tran_record.amount)
        FROM   tran_record
        WHERE  tran_record.acct_no = T1.acct_no
       (SELECT bill_master.alt_bill_group
        FROM   bill_master B1
        WHERE  B1.bill_code = tran_record.bill_code) AS bill_group) AS TV_amt
FROM  dbo.ACCT_MASTER T1
WHERE ACCT_NO = '431101590001'