Multiple table joining

Hi,


I have 7 database tables operating_systems_table,servers_table,others_table ,technologies_table,frameworks_table,languages_tab le,tools_table about a candidate.

According to his skills(i.e. if operatingsystem is Unix,server is Tomcat,technology is Webservices etc)I need the profileId of that candidate.

Possible to post table schema

tables -- skills_info_table
operating_systems _table
languages_table
technologies_table
frameworks_table
tools_table
servers_table
others_table

CREATE TABLE skills_info_table (
skills_info_id char(9) PRIMARY KEY ,
profile_id varchar(9) NOT NULL,
status varchar(10) default NULL);

CREATE TABLE operating_systems_table(
skills_info_id char(9),
skills_name varchar(50) );

CREATE TABLE languages_table(
skills_info_id char(9) ,
skills_name varchar(50));

CREATE TABLE technologies_table(
skills_info_id char(9) ,
skills_name varchar(50));

CREATE TABLE frameworks_table(
skills_info_id char(9) ,
skills_name varchar(50));

CREATE TABLE tools_table(
skills_info_id char(9) ,
skills_name varchar(50) );

CREATE TABLE servers_table(
skills_info_id char(9) ,
skills_name varchar(50));

CREATE TABLE others_table(
skills_info_id char(9) ,
skills_name varchar(50));