February 21st, 2013, 12:34 PM
I am trying to do a query that displays the customer name with the "customer" label. Here's what I've done so far:
SELECT a.account_id, a.cust_id, a.last_activity_date, a.open_emp_id,
CONCAT(e.fname, ' ', e.lname) as Opened_by, a.avail_balance
FROM account a INNER JOIN employee e
ON a.open_emp_id = e. emp_id
CONCAT (i.fname, i.lname, b.name) AS Customer
FROM individual i INNER JOIN business b
on b.cust_id = i.cust_id
WHERE NOT EXISTS (SELECT 1
FROM transaction t
WHERE t.txn_date = a.last_activity_date);
I got this error message:
Error Code: 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CONCAT (i.fname, i.lname, b.name) AS Customer
FROM individual i INNER JOIN busin' at line 5
It had been working great until I added the 2nd CONCAT & INNER JOIN.
Thanks in advance for helping someone who's still learning.
February 21st, 2013, 01:14 PM
I don't have the slightest idea what you're trying to do. What is this "2nd CONCAT & INNER JOIN" supposed to do?
In any case, the second CONCAT makes no sense in this context, and you cannot have multiple "FROM" and "WHERE" for a single query.
March 7th, 2013, 02:16 PM
how the result table looks like?
March 7th, 2013, 03:28 PM
there is only one SELECT clause in any query, and only one FROM clause
Originally Posted by bstar
you can't just patch on some new columns and a new FROM clause to an existing query
your first two tables, a nd e, are properly joined, and your second two tables, i and b, are also properly joined, but you will need either to set up two SELECTs in a UNION, or else find some way to logically connect a/e to i/b