Field names for columns from more than one table



If I create a query returning columns from more than one table, does FieldValues or FieldByName still work with field names ?
.