
February 21st, 2013, 10:35 AM
|
|
Registered User
|
|
Join Date: Feb 2013
Posts: 13
Time spent in forums: 3 h 55 m 24 sec
Reputation Power: 0
|
|
Display problems
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.
|