-
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));
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|