[fred2028]

Hi, is there a way to make simple logic for columns in a table? For example, if a value in 2 columns are equal, then set a third column to TRUE.

Thanks

[r937]

yes, but you would want to do this only in a SELECT query, not in the table itself as an actual column

[fred2028]

Originally Posted by r937

yes, but you would want to do this only in a SELECT query, not in the table itself as an actual column

Why is it not a good idea for the actual table to automatically change the 3rd column once the previous 2 columns are equal? I don't want to have to run a SELECT statement each time the table is updated.

[Vomster]

Seems like it would be another field to keep track of. Just worry about it at "run time".

That is the point r937 is trying to get across.

[r937]

Originally Posted by fred2028

I don't want to have to run a SELECT statement each time the table is updated.

i agree completely, and you're in luck, you don't have to

just do your updates as normal, and of course don't update this mythical third column because it won't even be there

when you want to see the data, that's the only time you do the SELECT, and that includes the calculation

[fred2028]

Originally Posted by r937

i agree completely, and you're in luck, you don't have to

just do your updates as normal, and of course don't update this mythical third column because it won't even be there

when you want to see the data, that's the only time you do the SELECT, and that includes the calculation

OK thanks!