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
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
Cheers,
Fred Liu
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.Originally Posted by r937
Cheers,
Fred Liu
i agree completely, and you're in luck, you don't have toOriginally Posted by fred2028
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
![]()
Last edited by r937; May 29th, 2012 at 08:37 PM.
OK thanks!Originally Posted by r937
Cheers,
Fred Liu