"Tim Harvey" wrote:

> Please bare with me in trying to get my point across, I'm new to SQL and
> would appreciate the help so much.
>
> I have two table Table1 and Table2. There is a one to many relationship
> between Table1 and Table2. Table2 has a list of widgets, I need to create a
> query that would show the records from Table1 along with it's related
> records and all non related records from Table2. So if I have 5 widgets and
> only two have related records in Table1 results should be
>
> Table1ID(2) fkTable2 Table2(widgetname1)
> Table1ID(2) fkTable2 Table2(widgetname2)
> null null Table2(widgetname3)
> null null Table2(widgetname4)
> null null Table2(widgetname5)
>
> When I filter the query on another Table1ID, I would need the same sort of
> result for each Table1ID.
>
>
>
>
>