Usman
Usman
Explore posts from servers
CC#DTDrizzle Team
PostsComments
DTDrizzle Team
Created by Usman on 12/23/2023 in #help
Multiple records with same columns and values - using joins
I am using innerJoins and this is the result I get. Sorry for the bad formatting. But except the fieldd (which is different in all results) I get everything else the same 
[
  {
    id: "abcd",
    // same fields
    fieldd: {
         "id": 4315,
         "module_d_id": 8969,
         "field_t_id": 28,
         "field_value": "9"
    }
  },
  {
    id: "abcd",
    // same fields
    fieldd: {
        "id": 4316,
         "module_d_id": 8969,
         "field_t_id": 29,
         "field_value": "75"
    }
  },
  {
    id: "abcd",
    // same fields
    fieldd: {
           "id": 4317,
           "module_d_id": 8969,
           "field_t_id": 30,
           "field_value": "Roof Repair Needed"
    }
  }
]
[
  {
    id: "abcd",
    // same fields
    fieldd: {
         "id": 4315,
         "module_d_id": 8969,
         "field_t_id": 28,
         "field_value": "9"
    }
  },
  {
    id: "abcd",
    // same fields
    fieldd: {
        "id": 4316,
         "module_d_id": 8969,
         "field_t_id": 29,
         "field_value": "75"
    }
  },
  {
    id: "abcd",
    // same fields
    fieldd: {
           "id": 4317,
           "module_d_id": 8969,
           "field_t_id": 30,
           "field_value": "Roof Repair Needed"
    }
  }
]
3 replies