Can anyone help me create a query to do the following:
I have to fields in a table and want to create a thrid field depending on the values in the other two.
What I need to do is select all the values from column2 and all the values from column1 when there is no coresponding value in column2.
eg.
Column1 Column2 Column3
1 158 158
0 45 45
34 0 34
Any help would be appreciated.
I have to fields in a table and want to create a thrid field depending on the values in the other two.
What I need to do is select all the values from column2 and all the values from column1 when there is no coresponding value in column2.
eg.
Column1 Column2 Column3
1 158 158
0 45 45
34 0 34
Any help would be appreciated.
