[RESOLVED] SQL Query HELP needed

[rwtrwt2003]

I have the following table layout
ID,Vendor,Switch,Postion,Emailaddress,YESorNO
1 lucent test MC s@ddd.com Y
2 lucent test ST s1@dd.com
3 lucent test1 DR s2@dd.com

What i want to do is if YESorNO = Y and Vendor = lucent i need the emailaddress to all switches that are the same as the ID 1

So after my query i need the following
Switch,Emailaddress
test s@dd.com
test s1@dd.com

here is the code that i got so far but if only gives me information for ID 1

SELECT * FROM `MailingList` WHERE `Vendor`='lucent' AND `yesorno` = 'Y' 

[WolfShade]

SELECT * FROM `MailingList` WHERE `Switch` = (SELECT `Switch` FROM `MailingList` WHERE `Vendor`='Lucent' AND `YESorNO` = 'Y')

[rwtrwt2003]

When i do the following command

SELECT * FROM `MailingList` WHERE `Switch` = (SELECT `Switch` FROM `MailingList` WHERE `Vendor`='Lucent' AND `YESorNOBWM` = 'Y') 

I get the following error
#1242 - Subquery returns more than 1 row

[WolfShade]

SELECT * FROM `MailingList` WHERE `Switch` IN (SELECT `Switch` FROM `MailingList` WHERE `Vendor`='Lucent' AND `YESorNO` = 'Y')