left join, Sql Server

left join

Language: Layout:

View schema
Execution time: 0,02 sec, rows selected: 15, rows affected: 11, absolute service time: 0,16 sec

edit mode | history

  
id
name
address

1
1
m1
addr1

2
2
m2
addr2

3
3
m3
addr3

4
4
m4
addr4


  
bill_id
member_id
tax_amount

1
1
1
100

2
2
2
200

3
3
3
300

4
4
4
400


  
receipt_id
member_id
paid_amount

1
1
1
100

2
2
3
300

3
3
4
200


  
name
address
tax_amount
paid_tax

1
m1
addr1
100
100

2
m2
addr2
200
not paid

3
m3
addr3
300
300

4
m4
addr4
400
200

λ

                                      .NET NoSQL database for rapid development