Advanced Search

Search:

Type: Posts; User: jbrack321; Keyword(s):

Search: Search took 0.00 seconds.

  1. Got it !!!! Looks like this gets the job done...

    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,...
  2. Trouble with select statement that combines 2 columns from 2 tables

    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...
  3. Thanks for the reply. I'm learning as I...

    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
  4. Trouble with select statement that combines 2 columns from 2 tables

    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 ...
Results 1 to 4 of 4