Hi i have two tables called GeneralTable and SpecializedTable which
has Name and State in It LIke
1 .GeneralTable ( GName , State )
2. SpecializedTable( SName , State )
i want to write an SQL query which display the State from where the majority of Person ( both General Table and SpecializedTable ) come from .
Can any one guide me.. i tried many thing but nothing worked . ..
NOte : i know i need to combine them into groups and need to sum , but dont know how to do this in database.