XML : How to select data from multiple nodes based on multiple condition in xslt?

I want to display the parts that are red and where supplier id is 1. how does one achieve this in xslt?

i have tried using this using xpath but i can only get values like if sid=1 and if color = red but not both!

  <table>      <suppliers>          <supply>              <sid>1</sid>              <sname> vishal</sname>              <address> wtf lane</address>            </supply>            <supply>              <sid>2</sid>              <sname> vishal</sname>              <address> wtf lane</address>            </supply>            </suppliers>        <parts>          <part>              <pid>1</pid>              <pname>kacha</pname>              <color>red</color>          </part>        </parts>        <catalogs>          <catalog>              <sid>1</sid>              <pid>1</pid>              <cost> 5 rs</cost>          </catalog>        </catalogs>    </table>