How to differ between Keys?

[AdrianCittadini]

Hi! I just noticed that, once you Load tables with a field with the same name on it, QView automatically connects them, using this field as a foreign Key.

Problem is, now only ONE column exists. How can I make an expression based on the field of one table or the other?

Example:

If I make a variable with COUNT(b_ID) I will get 4 (counting foreign keys of TABLE A). How can I COUNT the b_IDs as a PKey if Table B?

[Or · Accepted solution]

Load b_ID, b_ID as b_ID_NoKey, Name

From TableB;

And then count the new renamed field (rather than the key field).

Of course, in the specific example you described here, you could just count Name instead.