SQL Course Connection Query

Today, I mainly review the previous sub-query, and then learn the connection query join on the content.

Such as:

　　

Select Renyuan.code,name,age, Sex, Bumen.bname,bceo from Renyuan,bumen where Renyuan.bc=bumen.bcode

Write the above query statement as a connection query:

Select Renyuan.code,name,age, Sex, Bumen.bname,bceo from Renyuan joins Bumen on Renyuan.bc=bumen.bcode

After that, I learned about local variables.

Cases:

DECLARE @code int
Set @code =10003
Select age from Renyuan where [email protected]

SQL Course Connection Query