Dear All,
Is the possible to get this done by query?
===tblGroupBooking====
Checkin GroupCode
2016-May-01 abc001-A
2016-May-05 abc001-B
2016-May-08 abc001-C
2016-May-02 def002
2016-May-03 def003
I want the check in to be the first order, and BroupCode the second order. But If the group code has the same prefix (e.g. abc001), then they should stick to one another. Is that possible? Or is there's any other way to make the outcome look like this? Thanks in advance.
Best Regards,
Kevin
Is the possible to get this done by query?
===tblGroupBooking====
Checkin GroupCode
2016-May-01 abc001-A
2016-May-05 abc001-B
2016-May-08 abc001-C
2016-May-02 def002
2016-May-03 def003
I want the check in to be the first order, and BroupCode the second order. But If the group code has the same prefix (e.g. abc001), then they should stick to one another. Is that possible? Or is there's any other way to make the outcome look like this? Thanks in advance.
Best Regards,
Kevin
__._,_.___
Posted by: "zhaoliqingoffice@163.com" <zhaoliqingoffice@163.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar