SashaBuilder3
Programmer
Hi everybody,
Say, I have two tables t1 and t2:
Table t1:
f1 f2
---------
a 7
c 3
d 6
e 7
Table t2:
f1 f3
---------
a 5
b 2
d 1
f 3
I need to join the tables in a way to produce the following result table (matching rows by f1 field):
f1 f2 f3
------------
a 7 5
b . 2
c 3 .
d 6 1
e 7 .
f . 3
(dots represent NULLs)
Can anyone help me in writing a proper SQL statement?
Thanks,
Alexandre
Say, I have two tables t1 and t2:
Table t1:
f1 f2
---------
a 7
c 3
d 6
e 7
Table t2:
f1 f3
---------
a 5
b 2
d 1
f 3
I need to join the tables in a way to produce the following result table (matching rows by f1 field):
f1 f2 f3
------------
a 7 5
b . 2
c 3 .
d 6 1
e 7 .
f . 3
(dots represent NULLs)
Can anyone help me in writing a proper SQL statement?
Thanks,
Alexandre