help with a simple query - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

help with a simple query

help with a simple query# Database - 数据库

w*t2099-12-17 08:12

1 楼

I have a table like this
name JOB
-------------------
LEE J102
LEE J301
WANG A88
WANG A2
WANG A301
I need a query so that the result is:
name #jobs job-code
LEE 2 J102-J301
WANG 3 A88-A2-A301
I got problem with column "job-code" Anyone can help?

i*s2099-12-17 08:12

2 楼

YOu can not do that in a simple query.
If you want to implement in server, write Stored procedure
using cursor;
If you want to implement in client, that is much easier.

【在 w******t 的大作中提到】

: I have a table like this
: name JOB
: -------------------
: LEE J102
: LEE J301
: WANG A88
: WANG A2
: WANG A301
: I need a query so that the result is:
: name #jobs job-code

w*t2099-12-17 08:12

3 楼

Seems you are talking about SQL server. I'm working with access.
I wrote a VBA module and it works fine now.
thanks for the reply though.

【在 i**s 的大作中提到】

: YOu can not do that in a simple query.
: If you want to implement in server, write Stored procedure
: using cursor;
: If you want to implement in client, that is much easier.