Retrieving Data from Other Database Tables

In cases where the results of an SQL query are returned within the application's responses, an attacker can leverage an SQL injection vulnerability to retrieve data from other tables within the database. This is done using the UNION keyword, which lets you execute an additional SELECT query and append the results to the original query.

User Query

SELECT name, description FROM products WHERE category = 'Gifts'

Attacker Query

' UNION SELECT username, password FROM users--

Cause the application to return all usernames & passwords