Referencing or linking mysql tables

[eluser]bgreene[/eluser]
select t.loadnumber,t.date,p.license_number,t.field1,t.etc from transactions t left join producers p on p.id=t.producerid. use left join just in case a producer goes missing