Re: Joins to one table form two columns

select a.id, status1, detail from history a, statusText b where a.id = b.id; rob anderson wrote: > I am new to MySQL so don't laugh! > > > I have a table 2 fields that relate to another table (that stores the > description) > > i.e > > history > id > status1 > status2 > > > statusText > id

Joins to one table form two columns

I am new to MySQL so don't laugh! I have a table 2 fields that relate to another table (that stores the description) i.e history id status1 status2 statusText id details How can I join the history.status1 and history.status2 fields to the statusText table? in order that I can display id