getting data from two different tables problem

[eluser]haris244808[/eluser]
[quote author="TheFuzzy0ne" date="1364141470"]It will need some modification, but this should get you started.

Note: We're only using one loop.

Code:

<table>
    <thead>
        <tr>
            <td>
                Subject
            </td>
            <td>
                Description
            </td>
            <td>
                Created By
            </td>
            <td>
                Came From
            </td>
        </tr>
    <thead>
    <tbody>&lt;?php foreach ($files_query as $entry): ?&gt;

        <tr>
            <td>
                &lt;?php echo htmlentities($entry->subject); ?&gt;
            </td>
            <td>
                &lt;?php echo htmlentities($entry->description); ?&gt;
            </td>
            <td>
                &lt;?php echo htmlentities($entry->uploader_first_name.' '.$entry->uploader_last_name; ?&gt;
            </td>
            <td>
                &lt;?php echo htmlentities($entry->recipient_first_name.' '.$entry->recipient_last_name; ?&gt;
            </td>
        </tr>&lt;?php endforeach; ?&gt;

    </tbody>
</table>

I've picked different field names, so it's up to you to name them correctly.[/quote]

but files_query contains only the data from the 'files' table :

i need also full name of creator and sender to show to the same field all data together in the table)