Results 1 to 3 of 3

Thread: Multiple table joining

  1. #1
    Join Date
    Jul 2008
    Posts
    2

    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.

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Possible to post table schema

  3. #3
    Join Date
    Jul 2008
    Posts
    2
    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
  •