package main
import (
	"database/sql"
	"fmt"
	"log"
	_ "github.com/go-sql-driver/mysql"
)
type Person struct {
	Name string
	JobID int
}
type Job struct {
	JobID int
	Name string
}
func main(){
	cnn, _ := sql.Open("mysql", "user:password@tcp(host:port)/dbname")
	rows, _ := cnn.Query("SELECT name, job_id FROM persons")
	defer rows.Close()
	for rows.Next() {
		var person Person
		if err := rows.Scan(&person.Name,&person.JobID); err != nil {
			log.Fatal(err)
		}
		var job Job
        // This is N+1 query
		if err := cnn.QueryRow("SELECT job_id, name FROM Jobs WHERE job_id = ?",person.JobID).Scan(&job.JobID,&job.Name); err != nil { 
			log.Fatal(err)
		}
		fmt.Println(person.Name,job.Name)
	}
}