new to sql

I need something like

Select Users.x_firstname, Users.x_lastname, AND DISPLAY Users.x_phone,
IF (((Users.I_want_to_be_contacted_about_locum_vacanc ies_delete_as_appropria)=True) AND ((Users.vacancies_If_Yes_I_would_like_to_be_contac ted_by_home_telephone)=True)

Select Users.x_firstname, Users.x_lastname, AND DISPLAY Users.x_fax,
WHERE (((Users.I_want_to_be_contacted_about_locum_vacanc ies_delete_as_appropria)=True) AND
((Users.vacancies_If_Yes_I_would_like_to_be_contac ted_by_fax)=True));

FOR ALL THESES

Users.x_phone, Users.x_fax, Users.x_email, Users.mobile

Hope you can help