I need some help with a query

Question

I need some help with a query

progmgppers

Grasshopper

Points: 12
More actions
October 23, 2017 at 7:55 am

#325903

Hi,
I need some help with a query. In the picture you see three tables.
I want all rows in tblSales and ProdDesc from tblProctAttributes.
The problem I am running into is, if there is no record in ProductAttributes which corresponds to tblProducts.ProductSKU then the tblSales row gets filtered out. does anyone know a way around this?
Thanks

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Thom A SSC Guru Points: 99126 More actions · Answer 1

Instead of using a JOIN, try using a LEFT JOIN to your tblproductAttributes.

If you want a more in depth answer (with an example), have a look at the link in my signature, that explains how to post T-SQL questions. 🙂

Thom~

Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk

drew.allen SSC Guru Points: 76944 More actions · Answer 2

progmgppers - Monday, October 23, 2017 7:55 AM
Hi,
I need some help with a query. In the picture you see three tables.
I want all rows in tblSales and ProdDesc from tblProctAttributes.
The problem I am running into is, if there is no record in ProductAttributes which corresponds to tblProducts.ProductSKU then the tblSales row gets filtered out. does anyone know a way around this?
Thanks

The query designer produces ugly code and it's useless if you want to do anything complex. You're better off learning to just write out your code by hand.

Drew

J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 3

drew.allen - Tuesday, October 24, 2017 1:40 PM
progmgppers - Monday, October 23, 2017 7:55 AM
Hi,
I need some help with a query. In the picture you see three tables.
I want all rows in tblSales and ProdDesc from tblProctAttributes.
The problem I am running into is, if there is no record in ProductAttributes which corresponds to tblProducts.ProductSKU then the tblSales row gets filtered out. does anyone know a way around this?
Thanks
The query designer produces ugly code and it's useless if you want to do anything complex. You're better off learning to just write out your code by hand.
Drew

Co-worker of mine is just now learning this himself.