hi friends i have small doubt in sql server plz tell me how to solve
i have 2 tables and data contains like
id , color , colorid
1 , red , 10
2 , white , 20
and 2nd table contains like
colorid , name
10 , carrote
10 , tammoto
20 , sugar
20 , milk
based on this table i want output like below
white sugar ,milk
actualy i follow query inner join concept .but iam not get exactely this output.
plese tell me how to write query to solve this issue in sql server.