SELECT p.gene_id, s.gene_id AS SecGene, ...

##</code><code>##

... FROM primary LEFT JOIN secondary ON primary.gene_id=secondary.gene_id ...