February 21st, 2013, 11:35 AM
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, 11:50 AM
Wrong forum. This one is for Postgres
Originally Posted by bstar
I will not read nor answer questions where the SQL code is messy and not formatted properly using [code] tags.
Tips on how to ask better questions:
February 21st, 2013, 12:32 PM
Sorry. I guess I clicked on it my mistake.
Originally Posted by shammat