Querying 2 tables

Hi,

I have 2 tables "users" and "events" in one query I want to return

profilePic, firstname, surname from clients

and

eventName from events

The tables both have clientID which is passed via the URL.

This is what i have so far.

<cfquery name="qGetUser" datasource="#application.datasource#">
    
     Select profilePic, firstname, surname, eventName FROM clients, events WHERE #URL.clientID# = clients.clientID = events.clientID
     </cfquery>

Thanks