Re: Zwracanie dat bez sprzedaży (ms access 2013, sql)

Article View: pl.comp.bazy-danych.msaccess

Article #137175

Back to pl.comp.bazy-danych.msaccess Previous Next

#137175

From: MaciejF
Date: Wed, 04 May 2016 20:00

8 lines
1554 bytes

Może ten null nie jest potrzebny czyli tak:

SELECT d.datum, s.date_from, s.qty_sold 
FROM tbDATES AS d LEFT JOIN tb_art_agreg AS s ON d.datum = s.date_from 
WHERE ((s.article_id = 1034272) and (d.datum between #1/1/2016# and #1/5/2016#));

Pozdrawiam
MF

Technical Details

Message-ID: <b284da2c-3304-40b3-8b59-f3fe33ef6e16@googlegroups.com>

Path:

mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.icm.edu.pl!newsfeed.pionier.net.pl!feeder.erje.net!2.us.feeder.erje.net!news.glorb.com!88no1604024qga.1!news-out.google.com!uv8ni137igb.0!nntp.google.com!sq19no2575678igc.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail

References: <878ca8a1-a11b-4bfc-8299-93a657c4afc7@googlegroups.com>

Show Full Headers

Complete Article Headers

X-Received: by 10.159.35.74 with SMTP id 68mr6686747uae.14.1462392010868;        Wed, 04 May 2016 13:00:10 -0700 (PDT)
X-Received: by 10.50.118.73 with SMTP id kk9mr365243igb.9.1462392010775; Wed, 04 May 2016 13:00:10 -0700 (PDT)
Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.icm.edu.pl!newsfeed.pionier.net.pl!feeder.erje.net!2.us.feeder.erje.net!news.glorb.com!88no1604024qga.1!news-out.google.com!uv8ni137igb.0!nntp.google.com!sq19no2575678igc.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups: pl.comp.bazy-danych.msaccess
Date: Wed, 4 May 2016 13:00:10 -0700 (PDT)
In-Reply-To: <878ca8a1-a11b-4bfc-8299-93a657c4afc7@googlegroups.com>
Complaints-To: groups-abuse@google.com
Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=178.36.124.162; posting-account=kc7ZIQoAAAB5PkdJgxjq1dd8jnBK4MVp
NNTP-Posting-Host: 178.36.124.162
References: <878ca8a1-a11b-4bfc-8299-93a657c4afc7@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <b284da2c-3304-40b3-8b59-f3fe33ef6e16@googlegroups.com>
Subject: Re: Zwracanie dat bez sprzedaży (ms access 2013,
 sql)
From: MaciejF <maciejfr@onet.pl>
Injection-Date: Wed, 04 May 2016 20:00:10 +0000
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

Reply to Parent Message