I'm having a difficult time translating this SQL script to to JDatabase because I can't find the AND query. 

<pre>SELECT user.firstname, user.lastname, leadership.leadname, leadership.lead_des
FROM CLUB,LEADERSHIP,USER
WHERE CLUB.CLUB_ID=11
AND LEADERSHIP.USER_ID=USER.USER_ID
AND CLUB.CLUB_ID=Leadership.CLUB_ID;</pre>

I was looking at the [JDatabase documentation][1] but don't see anything in there with AND.


  [1]: https://docs.joomla.org/Selecting_data_using_JDatabase