rspec/rules/S2548/plsql/rule.adoc

== 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[]