If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
union query without "blank" recordsl
I have a union query between 2 related tables, and where they may be records
in one table [FixtureTypes] with no value in the other [FixtureCatalogsPages ]. I've got this (below) query written, which successfully joins the 2; however, it still provides a record when there is no match. I want the query to provide ONLY records for where there is a match between the 2 tables. I suspect I should be using some sort of property or filter? SELECT FixtureTypes.Type, FixtureTypes.Manufacturer, FixtureTypes.CatalogNo AS CatalogNumber, FixtureCatalogsPages.CatalogSheetLink, FixtureCatalogsPages.printOrder FROM FixtureTypes LEFT JOIN FixtureCatalogsPages ON (FixtureTypes.CatalogNo = FixtureCatalogsPages.CatalogNumber) AND (FixtureTypes.Manufacturer = FixtureCatalogsPages.Manufacturer); any thoughts and suggestions will be greatly appreciated in advance, thanks, mark |
Thread Tools | |
Display Modes | |
|
|