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

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;

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