I need to generate a MySQL query based on a field from a table. My database contains 2 tables. On each record found by the query I need to include data from the other table. This other data should be linked based on a specific field on the record found by the main query.
Hope I have explained myself.