i got 3 tables that i would like to link to each other... what i need is to select where 'tid' from table3 is equal to 'id' on table2, and from table2 i need to select where 'cid' on table2 is equal to 'id' on table1, now this is pretty confusing so i can't really figure it out because i don't really know how to select from multiple tables at once...