16f6c0aecf
Inline adoc files when they are included exactly once. Also fix language tags because this inlining gives us better information on what language the code is written in.
53 lines
865 B
Plaintext
53 lines
865 B
Plaintext
== Why is this an issue?
|
|
|
|
When multiple tables are involved in a query, using table aliases helps to make it more understandable and keeps it short.
|
|
|
|
|
|
=== Noncompliant code example
|
|
|
|
[source,sql]
|
|
----
|
|
BEGIN
|
|
SELECT
|
|
name,
|
|
firstname,
|
|
location
|
|
INTO employeesArray
|
|
FROM employee -- Noncompliant - should be aliased
|
|
INNER JOIN department -- Noncompliant - should be aliased
|
|
ON employee.DepartmentID = department.ID;
|
|
END;
|
|
/
|
|
----
|
|
|
|
|
|
=== Compliant solution
|
|
|
|
[source,sql]
|
|
----
|
|
BEGIN
|
|
SELECT
|
|
empl.name,
|
|
empl.firstname,
|
|
dpt.location
|
|
INTO employeesArray
|
|
FROM employee empl
|
|
INNER JOIN department dpt
|
|
ON empl.DepartmentID = dpt.ID;
|
|
END;
|
|
/
|
|
----
|
|
|
|
ifdef::env-github,rspecator-view[]
|
|
|
|
'''
|
|
== Implementation Specification
|
|
(visible only on this page)
|
|
|
|
=== Message
|
|
|
|
Add aliases for the tables in this query.
|
|
|
|
|
|
endif::env-github,rspecator-view[]
|