?

[xyz1]

.

[avinashelite]

try like this

TableA:

LOAD AssetTag,

Type

from

where Type='Windows 2003';

TableB:

LOAD *

where Exists(AssetTag,name);

TableC:

LOAD

*

where Exists(name,nameS);

hope this gives you the desired results

[xyz1]

.

[avinashelite]

did not get you ..could you explain with an example ? so that I could write the logic accordingly