大家帮忙看看这句SQL语句是什么意思

[inshine]

Select a.*, b.SortName as SortName from Department a, WorkSort b where a.WorkSortID = b.ID and a.RoomID like '102'

[lsxaa]

Select a.*, b.SortName as SortName --取出a表中全部字段和b表的sortname字段

from Department a, WorkSort b --a、b 是表的别名

where a.WorkSortID = b.ID and a.RoomID like '102' --条件是a.WorkSortID 对应 b.ID,而且a.RoomID 为'102'

[vinsonshen]

楼上说得很详细了，另：建议楼主好好看看基本的SQL语法吧

[luyulei]

sdasd