By navs on

I want to be able to create a view that does the equivalent of this:

Select the book's title where book.grade_level = learner.grade

Book conetnt type has a CCK field called grade_level and learner is a user profile with field called "grade".
How can I do this?
Navs

⋅ Categories: Drupal 6.x

Comments

navs’s picture

navs commented

I didnt think this question would receive no response for so long.

So here I go rephrasing it one more time.

How do I write a custom sql query for my views in drupal 6.x?
Please help
thanks
Navs

navs’s picture

navs commented

Thanks Lee VH. I couldn't have done this without your guidance. For the rest of the community, this needs a custom module implementation and Lee showed me how to get this done. Thank you.
Navs