General Questions about SQL commands

I have questions regarding some commands on SQL

1)What is the difference between using the INNER JOIN function and the JOIN function?

2)When rounding numbers on SQL, an example was DECIMAL (5,2). The 2 means to round to 2dp but what does the 5 mean?

Thank you

1 Like

JOIN performs an INNER JOIN by default.

SELECT *
FROM TableA
[Specify Optional] JOIN TableB ON TableA.ColX = TableB.ColY

DECIMAL(Precision, Scale) OR DECIMAL(TotalLength, DecimalPlaces)

The first number (in your case 5) is the max length of the number (INCLUDING the decimal places), so with a scale of 2 decimal the number will have this structure: 123.45.

2 Likes