Alexander AlexaderLex

We couldn’t find that file to show.


	SELECT p.productName, pl.productLine, c.customerName
	FROM productlines AS pl INNER JOIN products AS p
	ON pl.productLine = p.productLine
	INNER JOIN orderdetails AS od
	USING (productCode)
	INNER JOIN orders AS o
	USING (orderNumber)
	INNER JOIN customers AS c
	USING (customerNumber)

	-- phpMyAdmin SQL Dump
	-- version 4.8.5
	-- https://www.phpmyadmin.net/
	--
	-- Host: localhost:8889
	-- Generation Time: Jun 07, 2019 at 07:58 AM
	-- Server version: 5.7.25
	-- PHP Version: 7.3.1

	SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

	CREATE FUNCTION full_name(first_nm CHAR(20), last_nm CHAR(30) )
	RETURNS CHAR(60) DETERMINISTIC
	RETURN CONCAT(first_nm, ' ', last_nm);