select inner join query in mysql

See more:

MySQL

hi..

i have two tables...
1st table:
name
type

2nd table:
id
supplier id
member id

now i have to fetch member name where supplier id=4

but supplier name n member name is in the same column,so when i pass the condition,i only get supplier name,but i have to show member name...how to do this in mysql???