Hello,

I have 2 tables with the following schema

listings_members
-bid
-member

listings_type
-bid
-type

I want to be able to select all bid's from listings_type but only if the bid is in listings_members and member is set to "Yes"

I know there is a way to do it but im having trouble writing the sql statement. Any help would be apprecated.

this is what i have

PHP Code:

$sql = "SELECT bid.listings_type, bid.listings_members FROM listings_type,listings_members where type.listings_type = '$type' and bid.listings_members = 'Yes'"; 


Any help would be appreciated

nevermind got it

PHP Code:

$sql = "SELECT * FROM listings_type,listings_members  WHERE listings_type.bid=listings_members.bid and listings_type.type = '$type' and listings_members.member = 'Yes' ";