OpenForum RSS: Mysqljoin

Mysqljoin (DeadLoco)

Mon, 10 Jun 2013 16:50:07 GMT

> �� ? � �� ?

� �� . �� , � �� , �� , � �� , �� . ��:

[code]
SELECT w.id, w.name, z.title AS job_title, s.title AS tool_title
FROM users AS w
JOIN jobs AS z ON z.id = w.job_id
JOIN tools AS s ON s.id = z.tool.id
WHERE s.id = somevalue
AND w.id IN (1,3,5,7)
ORDER BY w.id, z.id, s.id;
[/code]�[code]
SELECT users.id, users.name, jobs.title AS job_title, tools.title AS tool_title
FROM users
JOIN jobs ON jobs.id = users.job_id
JOIN tools ON tools.id = jobs.tool_id
WHERE tools.id = somevalue
AND users.id IN (1,3,5,7)
ORDER BY users.id, jobs.id, tools.id;
[/code]

Mysqljoin (reverb)

Mon, 10 Jun 2013 16:08:16 GMT

>[�� ]
> [code]SELECT w.*
> FROM table AS w
> WHERE w.key = blabla
> ORDER BY w.value ASC;
> SELECT w.value
> FROM table1 AS w
> JOIN table2 AS z ON z.id = w.zid
> WHERE w.key = blabla
> AND z.key = foofoo
> ORDER BY w.value ASC;[code]

�� ? � �� ?

Mysqljoin (DeadLoco)

Mon, 10 Jun 2013 10:31:02 GMT

> ��, �� id :)

�� : �� , �� .
[code]SELECT w.*
FROM table AS w
WHERE w.key = blabla
ORDER BY w.value ASC;

SELECT w.value
FROM table1 AS w
JOIN table2 AS z ON z.id = w.zid
WHERE w.key = blabla
AND z.key = foofoo
ORDER BY w.value ASC;[code]

Mysqljoin (reverb)

Fri, 07 Jun 2013 18:11:45 GMT

>[�� ]
> |
> | 3 | �� | 5 | ��̣��
> |
> +----+-----------+----+---------------------+
> 9 rows in set (0.00 sec)
> �� SELECT id,name,description FROM nomenclature INNER
> JOIN description;
> Mysql �� ERROR 1052 (23000): Column 'id' in field list is
> ambiguous
> �� ?

��, �� id :)
�� .