I'm trying to join three tables to pull back a list of distinct blog posts with associated assets (images etc) but I keep coming up a cropper. The three tablets are `tblBlog`, `tblAssetLink` and `tblAssets`. The Blog tablet hold the blog, the asset table holds the assets and the Assetlink table links the two together.

`tblBlog.BID` is the PK in blog, `tblAssets.AID` is the PK in Assets.

This query works but pulls back multiple posts for the same record. I've tried to use select distinct and group by and even union but as my knowledge is pretty poor with SQL - they all error.

I'd like to also discount any assets that are marked as deleted (tblAssets.Deleted = true) but not hide the associated Blog post (if that's not marked as deleted). If anyone can help - it would be much appreciated! Thanks.

Here's my query so far.... 

```
SELECT dbo.tblBlog.BID,
       dbo.tblBlog.DateAdded,
       dbo.tblBlog.PMonthName,
       dbo.tblBlog.PDay,
       dbo.tblBlog.Header,
       dbo.tblBlog.AddedBy,
       dbo.tblBlog.PContent,
       dbo.tblBlog.Category,
       dbo.tblBlog.Deleted,
       dbo.tblBlog.Intro,
       dbo.tblBlog.Tags,
       dbo.tblAssets.Name,
       dbo.tblAssets.Description,
       dbo.tblAssets.Location,
       dbo.tblAssets.Deleted AS Expr1,
       dbo.tblAssetLink.Priority
FROM   dbo.tblBlog
       LEFT OUTER JOIN dbo.tblAssetLink
         ON dbo.tblBlog.BID = dbo.tblAssetLink.BID
       LEFT OUTER JOIN dbo.tblAssets
         ON dbo.tblAssetLink.AID = dbo.tblAssets.AID
WHERE  ( dbo.tblBlog.Deleted = 'False' )

ORDER  BY dbo.tblAssetLink.Priority, tblBlog.DateAdded DESC 

```

*EDIT*

Changed the `Where` and the `order by`....

Expected output:

```
tblBlog.BID = 123

tblBlog.DateAdded = 12/04/2015

tblBlog.Header = This is a header

tblBlog.AddedBy = Persons name

tblBlog.PContent = *text*

tblBlog.Category = Category name

tblBlog.Deleted = False

tblBlog.Intro = *text*

tblBlog.Tags = Tag, Tag, Tag

tblAssets.Name = some.jpg

tblAssets.Description = Asset desc

tblAssets.Location = Location name

tblAssets.Priority = True

```