There's a typo in your select statement: MembershipFied should probably be MembershipField.
It also looks like you may be using your sub-selects wrong (inside the parenthesis). This type of sub-select will take whatever is output from the SELECT statement and put it in there where the sub-select is located. So, for example, let me make up some cells for your tbl2 and tbl3 (i don't know what's actually in those tables). MySQL will first run what's inside the parenthesis and leave you with a SELECT statement that looks something like this:
SELECT field1,field2,field5,MembershipField from tbl1, 3,2,1, 5,4,3,2, WHERE MembershipFied=$membership_type
This type of SELECT statement doesn't make any sense. Could you explain in more detail what you want to accomplish with your database?