Community

join two content type and get the values in a view

Hi,
I have two content type
1) company profile (Company_name, address, etc) --- only one profile can be created by the user
2) package (itemname, price , desc) -- many package can be created by the user (item name is coming from taxonomy)

common field in both of them is the userid who created it.

now I want to display price, itemname, Company_name of a particular itemname (exposed filter) of all users through a view

I know it would be easy enough to get the data if profile would have been inside the user as field, but there are various profile for various user so cannot put the field inside user profile.

Please help

Thanks for any help... in advance

Comments

Discussed if not answered

Discussed if not answered here http://drupal.org/node/748844