Re: Need expert assistance with this (MySQL routine)

> > With the second approach you present I am getting a parse error,
> > unexpected ')' in /usr/home/test.php on line 14
>
> Change mysql_query($update)) into mysql_query($update);


Hmm, now after changing that now I get parse error, unexpected '}' in
/usr/home/test.php on line 15


> > On the first one, I am getting this : MySQL said: Documentation
> > #1064 - You have an error in your SQL syntax near 'customer1 from
> > customer1,customer WHERE customer1.column1 = customer.column1' at line
> > 1



> The query is valid, so are you sure the table customer1 exists?

Definitely, I have a customer and customer1 table (I know, for
consistency I should have customer1 and customer2), but I definitely
have two separate tables

I really appreciate your time on this with me.

Sincerely, Carly

.

Relevant Pages

  • RE: update query with summary
    ... Use a totals query with criteria of zero on the sum, ... Use that query INNER join on both fields in your delete query. ... customer1 LA -100.00 ... customer2 is different in city, i don't want that field to be closed. ...
    (microsoft.public.access.queries)
  • The column prefix MS1 does not match with a table or alias name used in the query. (#107)
    ... One query looks like this, ... SELECT Customer1 overall.*, ... Customer1 Field, Customer1 Staff, and Customer1 Overall are each ... queries with certain where clauses. ...
    (comp.databases.ms-access)
  • Max date
    ... I have a query that looks that this: ... Customer1 Loan#1 Date Rate ... I need to be able to pull the max date for each loan # for each customer, ... but that's not woring like I need it to ...
    (microsoft.public.access.queries)