关于SQL查询的问题 [英] problem about query in sql

问题描述

有两个表pmaster_attendance和pmaster_shift，来自pmaster_shift的shiftid是FK IN pmaster_attendance然后选择如何按顺序选择记录并显示单独的

there is two table pmaster_attendance and pmaster_shift the shiftid from pmaster_shift is FK IN pmaster_attendance THEN HOW to select record siftwise and display separate

推荐答案

Select * from pmaster_shift ps内部在ps.pk_id = pf.fk_id上加入pmaster_attendance pa

按pf.pk_id

Select *From pmaster_shift ps inner join pmaster_attendance pa on ps.pk_id=pf.fk_id

group by pf.pk_id

分组

Select Cast(notes as nvarchar(max)) + 'SomeText' From NotesTable a

这篇关于关于SQL查询的问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！