I´m building a car rental system, I have 2 tables, one for the cars and one for the renting. I only want everything in the table 1 to be showed once, and everything that´s in the table 2 to be showed under table 1.

Let's say that my tables look like this:

Table 1
-------

* id
* car
* model

Table 2
-------

* id(same as table 1 id)
* rentstart
* rentstop
* renttimestart
* renttimestop`

**And I want it to be showed like this in a table:**

* Carid(t1) / car(t1) / model(t1)
* rentstart(t2)-rentstop(t2) / renttimestart(t2)-Renttimestop(t2)

**EXAMPLE:**

* 1 / BMW / 320
* 14.3.2013-14.3.2013 / 13:30-14:30
* 15.3.2013-15.3.2013 / 8:00-13:00
* 2 / Audi / A4
* 15.3.2013-15.3.2013 / 8:00-13:00

**This is what I have now:**

```
 $sqlquery = 
  "SELECT * FROM table1 
   LEFT JOIN table2 ON table1.id=table2.id 
   GROUP BY table1.id";

```

(sorry for my formatting)