SQL open 2 tables at the same time

Posted on 2007-08-08
Last Modified: 2010-03-20
Antoher SQL question... I have one Databse in Access.

Two Tables:

This is for a golf simulator. tblStrandhill contains the 18 holes of a course including Index and names etc.
tblScoreData contains tournament scores for players.

Now what I'm unable to do... I would like to open both tbl at the same time and be able to present the data.

SELECT * FROM tblStrandhill, tblScoreData

How do I present the data from the both of them??

Question by:dantegroup
    LVL 19

    Accepted Solution

    there has to be a field that is present in both tablesd

    for instance

    Select * from tblstrandhill join tblscoredata on tblstrandhill.index=tblscoredata.index

    again, it depends on the fields that are in both tables.
    LVL 19

    Expert Comment


    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    Join & Write a Comment

    If you find yourself in this situation “I have used SELECT DISTINCT but I’m getting duplicates” then I'm sorry to say you are using the wrong SQL technique as it only does one thing which is: produces whole rows that are unique. If the results you a…
    This article describes how to use the timestamp of existing data in a database to allow Tableau to calculate the prior work day instead of relying on case statements or if statements to calculate the days of the week.
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    733 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now