Search:

Got it !!!!

Looks like this gets the job done




select state, sum(datap) as total from (select tracker.state, tracker.data datap from tracker union all select precaution.state,...

Hi sniperman,

VERY new to MYSQL.....you might try below to see if it works.




$strQuery = "SELECT users.username, users.password, objects.obj1, objects.obj2 FROM users INNER JOIN ruler ON...

Thanks for the reply.

I'm learning as I go...very green right now...but no errors with the select statement.

Here's what is retrieved:

state datap
TX 1000
LA 10000
TX 100

Hello,

very new to MYSQL. Having trouble with select statement that combines 2 columns from 2 tables (summing column2 for all similar states in column1).

1st table = tracker
column1 = state ...