SELECT * FROM `#__users`

Enter SQL query to retreive the list of user names from Joomla! users table.

Note that you can use standard Joomla! '#_' prefix for database table names

<table>
    <thead>
        <tr>
            <th>Name</th>
            <th>User Name</th>
        </tr>
    </thead>
    <tbody>

Enter HTML code to display before the resulting list of data rows.

Table opening tag and column headers go here. Add column headers as required

        <tr>
            <td>{name}</td>
            <td>{username}</td>
        </tr>

Enter HTML code to display each data row returned by SQL query.

To insert data field, type it's name enclosed within curly barckets ({}).

Add fields for all data columns you want to display here

    </tbody>
</table>

Enter HTML code to display after the resulting list of data rows.

Place table closing HTML tags here