1,2,3 query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

table: users
columns: owner, admin, user
Query: create a fourth column called type when,

admin = 'y' insert a "3"
owner = 'y' insert a "2"
neither owner or admin = 'y' insert a "1"
both owner and admin = 'y' insert a "3"

Thanks folks.
 
A388517 said:
table: users
columns: owner, admin, user
Query: create a fourth column called type when,

admin = 'y' insert a "3"
owner = 'y' insert a "2"
neither owner or admin = 'y' insert a "1"
both owner and admin = 'y' insert a "3"
Click to expand...

(please don't name column 'type')

TypeVal: Choose(admin='y',3,owner='y',2,true,1)
 
Thanks, Gary. I think I'll be needing a bit more help.
What would the correct syntax?

SELECT *
choose(((admin='y',3,owner='y',2,true,1),'1', '2', '3')) as loginType from
listusers
 
SELECT
admin,
owner,
Choose(admin="y","3",owner="y","2",true,"1") as loginType
from
listusers
 
Back
Top