---
title: "SQL INNER JOINE tar bort grouper!"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/188614-sql-inner-joine-tar-bort-grouper"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "dwmedia"
published: "2011-12-19T22:46:38.000Z"
updated: "2011-12-19T22:46:38.000Z"
replies: 0
views: 448
page: 1
pages: 1
language: "sv-SE"
site: "webForum — webforum.nu"
rights: "Upphovsrätten till varje inlägg tillhör dess författare."
attribution: "Citera som: webForum, https://www.webforum.nu/amne/databaser-sql/188614-sql-inner-joine-tar-bort-grouper"
---

# SQL INNER JOINE tar bort grouper!

## #1 — dwmedia, 2011-12-19T22:46Z

Inner joiner tar bort grouper om dem inte hittar någon post under någon kategori, försöker kringgå det så här har jag provad med. 

Försökt göra en SELECT i SELECT för hämta grouper 1 gång och sedan inner joine för hämta data så om en group skulle sakna data så ska den bara echo ut typ 0,00 eller något istället än dölja den helt. 

```
          $sql = "SELECT * FROM (SELECT COUNT(*) as h, SUM(b.advertisers_reports_cpc_spent) as b, SUM(b.advertisers_reports_uv_spent) as c, SUM(b.advertisers_reports_cpm) as d,
                 SUM(b.advertisers_reports_cpm_spent) as e, SUM(b.advertisers_reports_lead_spent) as f, SUM(b.advertisers_reports_sale_spent) as g,
                 a.id, a.advertisers_campaign_name, a.advertisers_campaign_uid, a.advertisers_campaign_status, a.advertisers_campaign_bugget, a.advertisers_campaign_remaining, a.advertisers_campaign_start_date, a.advertisers_campaign_end_date,
                 b.advertisers_reports_cid,
                 c.advertisers_users_owners, c.advertisers_access_id
                 FROM Advertisers_users c
                 INNER JOIN Advertisers_campaign a ON c.advertisers_users_id = a.advertisers_campaign_uid
                 JOIN Advertisers_reports b ON b.advertisers_reports_cid = a.id
                 WHERE b.advertisers_reports_uid = '$act' AND c.advertisers_users_id = '$act' AND c.advertisers_access_id = '{$_SESSION['sess_id']}' AND c.advertisers_users_admin > '1'
          GROUP BY a.id ORDER BY a.advertisers_campaign_name ASC LIMIT ".$start.",".$antalSida.") AS Advertisers_campaign ORDER BY id DESC";
          $result = @mysql_query($sql) or die('<b>Error selecting data from '.$table.'</b><br />'.mysql_error());
          while ($row = @mysql_fetch_assoc($result)) {
```

Skulle ju gå lösa det med först ta ut grouperna ur en SQL fråga sedan göra COUNT under SQL, men finns det inge smidigare sätt?

Permalänk: https://www.webforum.nu/p/188614

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/188614-sql-inner-joine-tar-bort-grouper