mysql查询两张表

[yingdafeng1]

有两张表：（devices和organization）
devices主要有以下几个字段（title、description、coding...）
organization主要有以下几个字段（coding、orgname...）
问题：通过coding字段查询列出title、description、orgname三个字段的参数

[q806294478]

select a.title,a.discription,b.orgname from devices a,organization where a.coding=b.coding

[roguemaster]

[Quote=引用 1 楼 q806294478 的回复:]

select a.title,a.discription,b.orgname from devices a,organization where a.coding=b.coding
[/Quote]


别名中少了个b吧

[dengsilinming]

[Quote=引用 1 楼 q806294478 的回复:]
select a.title,a.discription,b.orgname from devices a,organization where a.coding=b.coding
[/Quote]

不仅在别名中少写了一个b,而且把a.description误写为a.discription了。正确的查询应该为：
select a.title,a.description,b.orgname from devices a,organization b where a.coding=b.coding

[parallelbgls]

select devices.title,devices.description,organization.orgname from devices,organization where devices.coding=organization.coding and devices.coding=...

[叶子]

select  a.title ,
        a.description ,
        b.orgname
from    devices a
        full join organization b on a.coding = b.coding