Jump to content

shadowfoxmi

New Members
  • Posts

    1
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

shadowfoxmi's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. Hello, I have a query with two joins on three tables. Here's the scenario. First table - >Projects Second table - >[Team Members] Third Table - >Roles and I have the join lik this projects join [team members] join roles (of course i have the correct syntax with the field names n stuff in my query) Let's say I'm trying to print Project Name, Team Member Name, Role Name it works fine. Now i hav a filter saying Role Name="Product Manager" That works fine too. The problem is since it is a equality condition, it is listing only the Project Names with a "Product Manager" in the team. But I want to be able to select all the projects listing the "Product Manager" and in case a team didn't have a "Product Manager", have null returned for Role Name and Team Member Name. I have tried all join options (left, right, full) ; nothing works because i'm trying to filter on "Product Manager". Any help on this would be greately appreciated. Thanks for your time.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.