How to get records from SQL

I have the SQL Server 2008 tables below:

Table A

ID          int         Not Null (primary ID)
No          int         NULL
Value       int         NULL
Flag        nchar(10)   NULL

      

        
        
        
      

    

Table B

ID          int         Not Null (primary ID)
No          int         NULL
Value       int         NULL
Flag        nchar(10)   NULL

      

        
        
        
      

    

and i Below is the data in Table A

ID     No      Value   Flag
1      1        12      1         
2      1        12      1         
3      1        25      1         
4      2        120     1         
5      3        36      2         
6      2        120     2         
7      6        1       1         
8      2        10      1         
9      6        10      2         
10     1        25      2         
11     2        120     1        

      

        
        
        
      

    

and there are no records in table B when i write below expression

SELECT     dbo.A.No, SUM(dbo.A.Value) AS [IN], SUM(ISNULL(dbo.B.Value, 0)) AS OUT
FROM         dbo.A LEFT OUTER JOIN
                      dbo.B ON dbo.A.NO = dbo.B.NO
WHERE     (dbo.A.Flag = N'1')
GROUP BY dbo.A.No

      

        
        
        
      

    

I am getting below result

No      IN      OUT
1       49       0
2       250      0
6       1        0

      

        
        
        
      

    

When I add WHERE (dbo.A.Flag = N'1') AND (dbo.B.Flag = N'1')

nothing comes ..

my question is how to get records from table B as 0 when B does not contain records or does not find B.Id

UPDATE: When I have data in table B then records are written.