sql vnútorné spojenie
SELECT field1, CASE field2
WHEN condition1 THEN 'result1'
WHEN condition2 THEN 'result2'
ELSE 'result'
END, field3
FROM table_name;
Dotaz Vnútorné Spojenie
SELECT
customer.customer_id,
first_name,
last_name,
amount,
payment_date
FROM
customer
INNER JOIN payment
ON payment.customer_id = customer.customer_id
ORDER BY payment_date;
Bahasa kode: SQL (Structured Query Language) ( sql )