So I have a table table 1 that I am looking to pull data from.
I like to pull the type car,truck and boat and group car and truck in one group called vehicle
my select statement would be something like this:
select type, amount from table 1 where (type) in('car','truck','boat)
I cant seem to know how to group car and truck in one group
any help is appreciated
Solved! Go to Solution.
Thanks! do I have to add a group by statement? how would the amount field be populated? would it roll up to the group type?