MySQl 5.0 Query or Stored Proc help

I am using MySQl 5.0 and am new to anything more than a simple query. I was wondering if might get some help creating a query or stored procedure that would take the following data where col1 in each table was the key and produce the results posted below the table data. Any help or ideas would be greatly appreciated.

example @ http://www.fsbe.com

Thanks,

Mark

 

looks like it's just a select 2 columns, left outer join.

select ta.col1, ta.col2, tb.col1, tb.col2, etc...
from ta
left outer join tb on ta.col1 = tb.col1
left outer join....

 

Thanks! I'll give it a shot.