By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
14 rows affected
account_code | ctel1 | ctel2 | ctel3 | cname | address |
---|---|---|---|---|---|
1 | 123456789 | 987654321 | bullshit | cname12 | address1 |
1 | 123456789 | dummy | 987654321 | cname11 | address1 |
2 | 123456789 | 987654321 | thenumber | cname22 | address2 |
2 | 123456789 | thenumber | 987654321 | cname21 | address2 |
4 | 123456789 | 987654321 | thenumber | cname42 | address4 |
4 | 123456789 | thenumber | 987654321 | cname41 | address4 |
calling | Tel1 | Tel2 | account_code | address | cname | telephone1 | telephone2 |
---|---|---|---|---|---|---|---|
thenumber | 123456789 | thenumber | 1 | address1 | cname11 | 123456789 | dummy |
thenumber | 123456789 | thenumber | 1 | address1 | cname12 | 123456789 | 987654321 |
thenumber | 123456789 | bullshit | 2 | address2 | cname21 | 123456789 | thenumber |
thenumber | 123456789 | bullshit | 2 | address2 | cname22 | 123456789 | 987654321 |
thenumber | 123456789 | thenumber | 4 | address4 | cname41 | 123456789 | thenumber |
thenumber | 123456789 | thenumber | 4 | address4 | cname42 | 123456789 | 987654321 |
account_code | Tel1 | Tel2 |
---|---|---|
null | 123456789 | thenumber |
1 | 123456789 | thenumber |
2 | 123456789 | thenumber |
4 | 123456789 | thenumber |
999 | 123456789 | thenumber |
calling | Tel1 | Tel2 | AccountNo | address | cname | telephone1 | telephone2 |
---|---|---|---|---|---|---|---|
thenumber | 123456789 | thenumber | 1 | address1 | cname11 | 123456789 | dummy |
thenumber | 123456789 | thenumber | 1 | address1 | cname12 | 123456789 | 987654321 |
thenumber | 123456789 | bullshit | 2 | address2 | cname21 | 123456789 | thenumber |
thenumber | 123456789 | bullshit | 2 | address2 | cname22 | 123456789 | 987654321 |
thenumber | 123456789 | thenumber | 4 | address4 | cname41 | 123456789 | thenumber |
thenumber | 123456789 | thenumber | 4 | address4 | cname42 | 123456789 | 987654321 |
thenumber | null | null | 999 | null | Invalid customer | 123456789 | thenumber |
thenumber | null | null | null | null | No customer | 123456789 | thenumber |