Help with a JOIN - select all table 1 and first entry on table 2

[bwcc]

Currently, this is my join:

 

SELECT * FROM mso_record LEFT JOIN mso_problem ON mso_record.tracking=mso_problem.tracking ORDER BY 1 DESC

 

This will pick all of mso_record and match them with all records in mso_problem where tracking is the same.  I am wanting to change that to where it only picks the first record in mso_problem where tracking is the same.

 

Any ideas?

 

TIA

[fenway]

ORDER BY 1 won't really do anything... you need LIMIT 1, but without a real order by clause, you'll just get a quasi-recent one.