SQL tutorial on inner join queries. Writing Queries to combine two tables in one results query.

From chapter 3.1 of Beginning SQL Joes 2 Pros (www.joes2pros.com). Learn how to use basic inner joins to see two tables in one results set.

Category:

Education

Tags:

• SQL
• Server
• T-SQL
• 2005
• 2008
• query
• Joes
• criteria
• select
• clause
• statement
• code
• lessons
• beginner
• tutorial
• databases
• training
• simple
• queries
• data
• information
• introduction
• easy
• learn
• Rows
• records
• columns
• fields
• entity
• table
• lingo
• terms
• inner
• Joins.

[Joes2Pros]

Hello 2yung4grey. This video is from the Joes2Pros Vol1 book ISBN-10: 143925317X ISBN-13: 978-1439253175.

To get the right software (costs $50) go the Joes2Pros web site and click "Buy Now". There will be about 10 items on this page, click the grey box.

[Joes2Pros]

You can concatenate the fields to do this. Let’s say your Employee table has an ID that is a combo of your SSN and FirstName. The Payrates table as a EmpID field. You would do this.

SELECT *

FROM Employee INNER JONI Payrates

ON Employee.SSN + Employee.FirstName = Payrates.EmpID

[Joes2Pros]

The tool used is called Camtasia 7.0.

[Joes2Pros]

Yes Indeed! For the upcoming Launch of the Vol3 later this month there will be a video to cover Primary and Foreign keys. If you are a subscriber you will get the notification as soon as it goes up. Otherwise keep checking back.

[Joes2Pros]

Yes it looks like you this is a query being used as a derived table. I cover that in Chapter 9 of "SQL Queries Joes 2 Pro" but here is a very quick lesson. If you want a query to act like a table just put in parenthesis and give it a name like this...

SELECT *

FROM (SELECT * FROM Location WHERE Country = ‘UK’) as UKLocation

Here it’s like you are selecting form a UKLocation table which is really derived from the Location table.

[QTPeLearn]

You are the best. Wonderful tutorial on Joins. Thanks Joes :-)

[Joes2Pros]

You are welcome! Glad you enjoyed it! You can download part of the book for free at the JoesPros web site.

[itchyfangaz]

Thanks, this tutorial was a last minute god-send for a 'Newbie' like myself.

[talichp2]

very nice, waiting for more :)

[ellie3637]

Perfect, thank you so much!

[2yung4grey]

Respond to this video... also what book are you referring to? 

[2yung4grey]

@Joes2Pros what software do i need to downlaod this type of software?. I downloaded oracle 11g r2, hoping i will get this exact type of software. I know it's sql plus but i cant download the software(Its already on my start menu under oracle installs). Please help. I'm trying to get ahead of my class before school starts. Thanks.

[2yung4grey]

@Joes2Pros what software do i need to downlaod this type of software?. I downloaded oracle 11g r2, hoping i will get this exact type of software. I know it's sql plus but i cant download the software(Its already on my start menu under oracle installs). Please help. I'm trying to get ahead of my class before school starts. Thanks.

[2yung4grey]

@Joes2Pros what software do i need to downlaod this type of software?. I downloaded oracle 11g r2, hoping i will get this exact type of software. I know it's sql plus but i cant download the software(Its already on my start menu under oracle installs). Please help. I'm trying to get ahead of my class before school starts. Thanks.

[Matalic1]

thank you man i love you !!!