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

[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!

[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.

[Matalic1]

thank you man i love you !!!

[Shlavlak]

Very helpful, thanks so much :)

[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

[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.

[2yung4grey]

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

[madprophetus]

Question: If I have multiple fields on one record that all reference the same field in another table (3 employees assigned to one project, for example), how can I join all three fields back to another table? Also, is there a way I can "rename" the fields in the joined query? I need to be able to see which joined employee name fits to which role field in my main table.

Thanks for the videos! These are a big help!

[Joes2Pros]

The tool used is called Camtasia 7.0.

[maabaig]

Excellent presentation and tutorial. What tool you use to create this Video please? Thanks.

[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.

[jirkovesely]

Nice tutorial, can you do something about PK and FK followed by Constraints? Will be very helpfull. I understand it from the book but somethimes is better when we see it from professional. Thanks

[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.

[starcatcher164]

Can u help me rewrite or explain this code in sql,i undestand d code but not all of it,also is [select count(*) from tblusers] also the same from [select * from tblusers]? FormAllowed = DBConn.Execute("SELECT Count(*) FROM (tblUsers AS u " & _ "INNER JOIN tblUserGroupPrivileges AS gp ON u.UserGroupID = gp.GroupID) " & _ "INNER JOIN tblForms AS f ON gp.FormID = f.FormID " & _ "WHERE u.[ID] = " & LogInUserID & " AND LCase(f.ObjectName) = LCase('" & FormName & "')").Fields(0).value > 0

[javed4401]

Thanks

[CamiloSanchez1979]

hey this is pretty fucking clear!..good job bro!

[easa83]

Thanks , clear and simple explanation, but I'm still confused about Natural join, is it the same as inner join?

[uhotatokyahota]

Thanks...

[Vishalpatel318]

SELECT *

FROM employee e, payrates p

WHERE e.empid=p.empid

Is that the same as running the inner join?

[Joes2Pros]

That is the old style way and has the same effect today as an inner join in most cases.

[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.

[Joes2Pros]

Thank you!!!

[ytsatheesh]

Excellent tutorial, keep up the good work.

[bsandrabr]

brilliant tutorial I'd been trying to work out how to use this function for ages very clear and concise

[Joes2Pros]

Very glad to hear that! You comment keeps me motivated to make more good videos.