Announcement

Collapse
No announcement yet.

Table join query

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Table join query

    Hi I have prepared a form the following table join query:

    $ check_sql =
    "SELECT
    tarifas.tipo,
    tarifas.grupo,
    tarifas.preciodia,
    tarifas.kilometros,
    tarifas.preciokm,
    tarifas.fianza,
    vehiculos.grupo,
    vehiculos.modelo,
    vehiculos.matricula
    FROM
    INNER JOIN rates ON tarifas.grupo = vehiculos.grupo vehicles
    WHERE
    (tarifas.tipo = 'Price') AND (vehiculos.matricula = '123456 ') ";

    sc_select (rs, $ check_sql);

    Now I would like to fields (tarifas.kilometros and tarifas.preciodia) update another table whose tuition is like I have already collected.
    I hope I explained.

    Thank you very much for your help.

  • #2
    Look at your first thread ...
    Best regards: - Reinhard -

    I use ScriptCase 8 Enterprise Edition, Version 8.(latest)

    Comment


    • #3
      Yes Richard! I absolutely agree with your bottom line!

      We need: less errors - bugtracker - english variable names - run on php 5.4/5.5 without zend guard - many others ...
      -----------------------------------------
      Arthur Klisiewicz
      dATA POINT SOFTWARE
      www.datapointsoftware.com

      Comment


      • #4
        Originally posted by aka View Post
        Yes Richard!
        I do not know ...
        Best regards: - Reinhard -

        I use ScriptCase 8 Enterprise Edition, Version 8.(latest)

        Comment


        • #5
          "quieropaginaweb", You want to put this result into another table? If so, then usse one "lookup"! lookup after you place an update in the table you want!

          Comment

          Working...
          X