Entry

PHPRunner: SQL query: Can you use a 'WHERE' in your SQL query? [SELECT / INNER JOIN / MySql]

May 21st, 2005 11:25
Knud van Eeden,

----------------------------------------------------------------------
--- Knud van Eeden --- 20 May 2005 - 00:16 am ------------------------

PHPRunner: SQL query: Can you use a 'WHERE' in your SQL query? 
[SELECT / INNER JOIN / MySql]

---

PHPRunner v2.0 beta

---

No, that is not possible in the current latest version

---

e.g.

--- cut here: begin --------------------------------------------------

SELECT
 column1,
 column2
FROM
 table1,
 table2
WHERE
 table1.primaryKey = table2.foreignKey
;

--- cut here: end ----------------------------------------------------

is not possible to use,
because the syntax contains this word 'WHERE'.

---

So you should rewrite you query, using the
'INNER JOIN' keyword.

---

e.g.

--- cut here: begin --------------------------------------------------

SELECT
 column1,
 column2
FROM
 table1
INNER JOIN
 table2
ON
 table1.primaryKey = table2.foreignKey
;

--- cut here: end ----------------------------------------------------

---

e.g.

--- cut here: begin --------------------------------------------------

SELECT
 table1.fieldname1,
 table1.fieldname2,
 ...
 table1.fieldnameLast
 table2.fieldname1,
 table2.fieldname2,
 ...
 table2.fieldnameLast
FROM
 table1
INNER JOIN
 table2
ON
 table1.primarykey = table2.foreignkey

--- cut here: end ----------------------------------------------------

---

e.g.

--- cut here: begin --------------------------------------------------

SELECT
 `table1`.`primaryKey`,
 `table1`.`column1`,
 `table1`.`column2`,
 `table2`.`column3`
FROM
 `table1`
INNER JOIN
 `table2`
ON
 `table1`.`primaryKey` = `table2`.`foreignKey`
;

--- cut here: end ----------------------------------------------------

---

e.g.

--- cut here: begin --------------------------------------------------

SELECT
 table1.primaryKey,
 table1.column1,
 table1.column2,
 table2.column3
FROM
 table1
INNER JOIN
 table2
ON
 table1.primaryKey = table2.foreignKey
;

--- cut here: end ----------------------------------------------------

---
---

Internet: see also:

---

SQL join
http://www.w3schools.com/sql/sql_join.asp

---

Database: MySql: PHPRunner: Link: Can you give an overview of links?
http://www.faqts.com/knowledge_base/view.phtml/aid/35950/fid/1805

----------------------------------------------------------------------