Easy Table join issue

[michaelbrux]

I have two tables and I can't seen to figure out how to join the tables and get the information I want. I have a master list of all users with their computer names and list of users who need software added. I need to make a 3rd table with all the users who need software added and include their computer name.


[TABLE="width: 500"]
<tbody>[TR]
[TD]User[/TD]
[TD]Computer Name[/TD]
[/TR]
[TR]
[TD]Bill[/TD]
[TD]Alpha[/TD]
[/TR]
[TR]
[TD]Frank[/TD]
[TD]Big[/TD]
[/TR]
[TR]
[TD]Joe[/TD]
[TD]Photon[/TD]
[/TR]
[TR]
[TD]Alice[/TD]
[TD]Jumbo[/TD]
[/TR]
</tbody>[/TABLE]


[TABLE="width: 500"]
<tbody>[TR]
[TD]User[/TD]
[TD]Add Software[/TD]
[/TR]
[TR]
[TD]Frank[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]Bill[/TD]
[TD]Yes[/TD]
[/TR]
</tbody>[/TABLE]

 

[Fahadfx]

Hi,

What I would do is link the two table using User as a key then add a new column in the first table with the computer names and use Related() to add the add software. The result if the user could be found in second table Yes would show in the new column otherwise Blank.

Thanks

 

[Norie]

No need to create a new table, try this query.

SELECT Table1.[User], Table1.[Computer Name]
FROM Table1 LEFT JOIN Table2 ON Table1.[User] =Table2.[User]
WHERE Table2.[Add Software] = 'Yes'

 

[michaelbrux]

No need to create a new table, try this query.

SELECT Table1.[User], Table1.[Computer Name]
FROM Table1 LEFT JOIN Table2 ON Table1.[User] =Table2.[User]
WHERE Table2.[Add Software] = 'Yes'

Ok Where do I enter this query? are the table names the excel tables or the power pivot tables?

 

[Norie]

Oops, didn't notice this was the PowerPivot forum.

What I posted is SQL for a query in Access (or any other database) so it's probably not relevant.

Apologies.

 

[Laurent C]

Creating a third table is not necessarily required.

I support Fahadfx's answer, although you might even consider not using the RELATED function and just create a relationship, and use a pivot table to get the desired output.