HI, lets say I have tow tables :
Item :

Field Field Name Type Width Dec Index Collate Nulls
1 ITEM Character 50 Asc Machine No
2 COST Integer 4 No

Bom :

Field Field Name Type Width Dec Index Collate Nulls
1 ITEMPARENT Character 50 No
2 ITEM Character 50 No
3 QUANTITY Integer 4 No

I have a query definition that is working well in Access but not in VFP.
SELECT Item.Item
FROM Item LEFT JOIN BOM ON Item.Item = BOM.ItemParent
WHERE ((BOM.ItemParent) Is Null)
GROUP BY Item.Item;

In Access I get the result "E", "F" and "G". But in VFP, nothing. Why is that ?

Thank tou,
Christian