lookup from a tabel and insert zeros in missing

[#1]

I am a bit stuck....again

Firstly thanx to all the people that replied to my questions....you know who you are!!!

I have two tables that I need to compare to find empty locations is a warehouse. Table 1 has the activity and table 2 hass all the locations.

What I need is to eliminate the locations on the master that has activity for example:

ON THE LOCATION MASTER TABLE IT MUST DO A "LOOKUP" OF ALL THE VALUES ON THE LEFT TABLE AND WHERE THERE IS NO VALUE IT SHOULD INSERT A ZERO USING THE LOCATION MASTER AS BASE TO LOOKUP FROM....

Thanx in advance

[#2]

Hi,

you achieve this with joining all the locations on the activitiy table. Then you have only to write in the next table the condition if(not IsNull(Qty), Qty, '0') AS Quantity and you have the zeros.

See attached examples.

Regards.