Logistics Health Incorporated

  www.logisticshealth.com
Work in HR? Unlock Free Profile

Logistics Health Incorporated Business Data Analyst Interview Question

I interviewed in La Crosse, WI and was asked:
"Write an SQL statement to join 2 tables together"
Add Tags [?]
Answer

Part of a Business Data Analyst Interview Review - one of 5 Logistics Health Incorporated Interview Reviews

Answers & Comments

0
of 0
votes
The answer depends on the DB schema, but the gist of it is, if you have TableA with columns C1, C2, and C3 and TableB with columns C4, C5, and C6, and you want to make sure that your join returns only the rows where the values in TableA.C3 are equal to the values in TableB.C5, then the join will look like this:

SELECT * FROM TableA JOIN TableB ON (TableA.C3 = TableB.C5);

That's about as generic as it can be, There are several different kinds of joins and syntaxes, but this is the idea.
- AlexUtiug on May 10, 2010

To comment on this question, Sign In with Facebook or Sign Up

Tags are like keywords that help categorize interview questions that have something in common.