linking database column entries if a is this then b is that

  • Thread starter Thread starter Renae96
  • Start date Start date
R

Renae96

I need help in linking several columns. If the first column is on thing then
that determines the contents of 3 other columns. How do you link them?
 
hi,
I need help in linking several columns. If the first column is on thing then
that determines the contents of 3 other columns. How do you link them?
Click to expand...
This makes no sense.

The only thing I can imagine:

SELECT
firstColumn,
IIf(firstColumn=oneThing, columnA, columnD),
IIf(firstColumn=oneThing, columnB, columnE),
IIf(firstColumn=oneThing, columnC, columnF)
FROM
yourTable

mfG
--> stefan <--
 
Back
Top