SQL join examples

SELECT seqlength, chromosome FROM Gene, Protein WHERE Gene.number=Protein.gene;

seqlength	chromosome
301	'21'

SELECT Protein.number FROM Gene, Protein
    WHERE Gene.first < Gene.last AND Gene.number=Protein.gene;

seqlength	chromosome

SELECT Protein.name, Protein.number, Gene.name FROM Gene, Protein
    WHERE Gene.first > Gene.last AND Gene.number=Protein.gene;

name	number	name
'leptin'	3	'OB'