layout | title |
---|---|
lecture |
SQL Joins |
SELECT yr, mo, dy, scientificname
FROM Main
JOIN Species ON species = new_code;
SELECT yr, mo, dy, scientificname
FROM Main
JOIN Species ON species = new_code
JOIN Plots on plot = PlotID;
SELECT m.yr, m.mo, m.dy, s.scientificname
FROM Main m
JOIN Species s ON m.species = s.new_code
JOIN Plots p on m.plot = p.PlotID;
SELECT species, scientificname
FROM Main
JOIN Species;
SELECT species, scientificname
FROM Main
JOIN Species WHERE species = new_code;