Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 5.3
Wiki Markup
Esimerkki sql-hausta moneen tauluun. 
{code}
querystring="SELECT *, sensor.name as sensorName, sensor.Type as sensorType "
                "FROM sensor, cylinder, machine  WHERE "
                "sensor.machine_id = machine.machine_id "
                "AND cylinder.cylinder_id = sensor.cylinder_id "
                "AND machine.ActiveMachine = 1";
{code}