Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2011

    Unanswered: Newbie Question - Query Multible Tables

    New to SQL of any type.

    My quesiton is, is there a way to put together a script to query 5 tables into 1 based on only 1 ID?

    - ATTR_ID is the only ID common between all 5 tables

    - Some tables may have a few common ID's between them

    Once assembled then will be exported to csv file for evaluation.

    Again, I've looked at a little bit of code for creating what I percieve for 2 tables. But lack the concept for doing more than 2.

    Any help will be greatly appreciated!

  2. #2
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    Select count(
    from taba a, tabb b, tabc c, tabd d, tabe e
    where =
    and =
    and = e,id
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts