Query Help

2003-03-11 Thread mpalikko
Very informative MySQL list. Good Job People! Query Question.. Two tables 1. Clients ClientID (Primary Key, Unsigned int , Auto_Increment) Vehicle typeChar(200) Vehicle Color CHAR(200) 2. Service ServiceID (Primary Key, Unsigned int ,

Query ?? Help !!!

2002-12-16 Thread mpalikko
Hello All, Great list ! MySQL = Incredible Product ! I've been trying to come up with a SQL query to perform the following... Table - Contact ClientID Activity1 Activity2 Activity3 Activity4 Time1 Time2 Time3 Time4 Date I need to get a total of all the activities and their associated time