TutorMe homepage
Subjects
PRICING
COURSES
SIGN IN
Start Free Trial
Dj B.
Business/Data Analyst who loves SQL!
Tutor Satisfaction Guarantee
SQL Programming
TutorMe
Question:

What is the difference between and inner join and an outer join?

Dj B.
Answer:

An inner join will give you the records from your two tables that they have in common. So if you are "inner joining" customer ID, you will only get results if both tables share the same customer ID as a record. An outer join (more than likely a left outer join or just left join) will give you all records from your first table and only the records from your second table that are shared. So if the customer ID is in the first table but not in the second table, the results will still show the customer ID. This can be used if you know you do not want to eliminate any records in your first table because they may not be shared in your second table.

Microsoft Excel
TutorMe
Question:

What is the VLOOKUP function and how do I use it?

Dj B.
Answer:

VLOOKUP is a simple way to search a separate data source (usually another sheet within the current spreadsheet, or a new spreadsheet altogether) for a matching record in order to retrieve additional bits of information (located in the same row) about the record that you currently do not have in your main spreadsheet. Here's an example: John Doe has a social security number in your main spreadsheet but there's no date of birth for John Doe. You need to populate his date of birth in a particular field in this spreadsheet. You have a second spreadsheet with social security numbers and date of births, but no names. Since you already know the social security number exists in both spreadsheets, you can retrieve the date of birth for John Doe using the VLOOKUP function. It will "search" for John Doe's social security number in the second spreadsheet and can return any information in that matched row - in this case his date of birth.

Microsoft Access
TutorMe
Question:

How do I know which fields from each table I have selected in my query are the fields needed to establish links or joins, so that my query returns the results I expect?

Dj B.
Answer:

The relationship between the tables is only as good as the unique identifiers in each table which are the primary keys. Think of it like this - At least two of the tables you're joining should have something to uniquely identify the records (for customer records, a customer ID is an example). A customer ID may or may not have a business, a phone number, or a contact in one or more tables, but those pieces of information will apply to a unique customer ID.

Send a message explaining your
needs and DJ will reply soon.
Contact DJ
Ready now? Request a lesson.
Start Session
FAQs
What is a lesson?
A lesson is virtual lesson space on our platform where you and a tutor can communicate. You'll have the option to communicate using video/audio as well as text chat. You can also upload documents, edit papers in real time and use our cutting-edge virtual whiteboard.
How do I begin a lesson?
If the tutor is currently online, you can click the "Start Session" button above. If they are offline, you can always send them a message to schedule a lesson.
Who are TutorMe tutors?
Many of our tutors are current college students or recent graduates of top-tier universities like MIT, Harvard and USC. TutorMe has thousands of top-quality tutors available to work with you.