Results 1 to 3 of 3

Thread: Joins

  1. #1
    Join Date
    Feb 2013
    Posts
    3

    Unanswered: Joins

    Hi All,

    I am very new to Datbase joins. So please bear with me about this simple basic question. I have given 3 tables as below.
    Table1
    ID OpenPrice

    Table2
    ID Close Price

    Table3
    ID ClientName

    Now I want a result set like this

    ID OpenPrice ClosePrice ClientName

    How can I achieve this by SQL joins? Can some one please help?

    Thank you,

    John

  2. #2
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    I suggest you look at this example and build from there
    SyBooks Online: Chapter 4: Joins: Retrieving Data from Several Tables

  3. #3
    Join Date
    Oct 2012
    Posts
    5
    Hello John, the SQL statement is :select ID,openPrice,closePrice,ClientName from table1,table2,table3 where table1.ID=table2.ID=table3.ID

    By the way, if you just want to print the result or show it on the spreadsheet, you can try esCalc. With esCalc, you can realiza your goal without writing any code.

Posting Permissions

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