| Joining tables |
|
|
|
|
|
|
|
| SELECT
b.name, b.ra, b.dec, b.mag bmag, |
||||||
| r.mag
rmag |
||||||
| FROM
bsources b, rsources r |
||||||
| WHERE
b.name = r.name; |
||||||
| result: |
||||||
| NAME RA DEC BMAG RMAG |
||||||
| ----------
---------- ---------- ---------- ---------- |
||||||
| NGC1234 12.34 45.67
17.3 19.3 |
||||||
| NGC4321 23.45 56.78
18.2 17.2 |
||||||