alias question

[IBazz]

Hi,

where I have a table 'products' with a column (currency char (3) ) and it is constrained to reference the table 'currencies.currency', which should I query when gathering columns from the products table; c.currency or p.currency?

if c.currency is ever updated, so will be p.currency so they should always have the same value and I reckon that if I can omit a join,. then I would have a more efficient query.

But, am I correct?

bazz

[longneck]

it doesn't really matter, but you MIGHT get a marginal performance improvement using p.currency, but only if you're also not retrieving any other columns from the currencies table.

[IBazz]

thank you longneck. :thumbsup:

I can see why there may be little performance gain but I think a simpler query might tax my brain less

bazz

[longneck]

i frequently trade performance for simpler implementation. complexity for performance reasons can come later once the whole application is done.