There are 3 tables:
Table A:
code aname
------- ---------
1 A
2 B
3 C
Table B:
code bname
----------- ----------
1 aaa
1 bbb
2 ccc
2 ddd
Table C:
code cname
----------- ----------
1 xxx
1 yyy
1 zzz
2 www
We need to write a query that would display the following result:
code aname bname cname
----------- ---------- ---------- ----------
1 A aaa xxx
1 A bbb yyy
1 A NULL zzz
2 B ccc www
2 B ddd NULL
3 C NULL NULL
Aucun commentaire:
Enregistrer un commentaire