Click here to Skip to main content
15,790,267 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:

i have two tables...
1st table:

2nd table:
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 to do this in mysql???
[no name] 6-Dec-13 2:09am    
Can you share few data of your table for better understanding..
Ganesh Raja 9-Dec-13 10:35am    
Which one is common column in both the table? or u r applying cross join?
Share some sample...
Maciej Los 9-Dec-13 16:51pm    
Totally unclear!

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900