Larry Brister
asked on
SQL Pivot
How can I do a select on a Specialties table and a states table
Specialties table has
SpecialtyID StateID
States table has
StateID StateName (Varchar(2))
So that I have this output
SpecialtyID AK AL AZ etc....
data count(AK) etc...
Specialties table has
SpecialtyID StateID
States table has
StateID StateName (Varchar(2))
So that I have this output
SpecialtyID AK AL AZ etc....
data count(AK) etc...
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
post your follow-up question
ASKER
ASKER
Watch for follow-up. I messed this question up actually