Following query joining 3 tables:

```
select * from product_group_pids as pgp  

join product_group_attributes pga on pga.group_id=pgp.group_id

join product_group_attribute_values pgav on pgav.group_id=pgp.group_id

where pgp.group_id = (219138)

```

In all 3 tables group\_id exits, Result will show 3 times the same group\_id. How can i restrict to display only once? Making alias names does not make sense to specify explicitly for multiple fields in tables. Can i get any suggestions to restrict with join statements?