Hello i have **two tables** with a PK---->FK Relationship in InnoDB Engine---->**MySQL&PHP**

The Relationship is **one---->many** between first table which is **'Properties'** and second 

table which is **'propertyimages'**. every row in first table is unique but in second table 

every row of first table has got many rows in second table How can i \*\*SELECT unique row from 

first table and all info about first table from second table here is my query:

```
SELECT DISTINCT properties.PropertyName, 
                properties.PropertyStatus, 
                propertyimages.PropertyImageID, 
                propertyimages.ImagePath 
FROM properties 
   INNER JOIN propertyimages 
      ON properties.PropertyImageID=propertyimages.PropertyImageID 
     AND propertyimages.PropertyImageID=8;

```

it gives result:

```

PropertyName    PropertyStatus     Propertyid       property Image Path
Appartment      For Lease          8                upload/hydrangeas.jpg
Appartment      For Lease          8                upload/jelsh.jpg
Appartment      For Lease          8                upload/penguins.jpg
Appartment      For Lease          8                upload/tulips.jpg

```

In this result the **PropertyName** and **PropertyStatus** is Repeated but i want a 

unique as its stored in the first tableThe **propertyName** and **PropertyStatus** 

belongs to first table.The **Propertyid** and **PropertyImagepath** belings to second table.