📄 15231.html
字号:
<html>
<head>
<title>Hierarchical RecordSet</title>
</head>
<body bgcolor="#FFFFFF" vlink="#808080">
<center>
<h1>Hierarchical RecordSet</h1>
</center>
<hr size=7 width=75%>
<hr size=7 width=75%><p>
Posted by <a href="mailto:sephiroth@optimasoft.com.tw">Sephiroth</a> on July 05, 1999 at 15:49:32:<p>
In Reply to: <a href="15119.html">这样子的案子,该如何下SQL</a> posted by vito on July 02, 1999 at 18:33:58:<p>
: 这样子的案子,该如何下SQL<p>: tableA客户资料<p>: custom_id, name ...<br>: ----------+-------<br>: 001 AAA<br>: 002 BBB<br>: 003 CCC<p>: <br>: tableB买卖记录<p>: custom_id, item<br>: ----------+---------<br>: 001 A01<br>: 002 A02<br>: 001 A04<br>: 001 A03 <br>: 003 A01<br>: 002 B03<p>: <br>: select A.custom_id,A.name,B.item from A,B<br>: where A.custom_id=B.custom_id<br>: and A.custom_id<>'003'<p>: 会得到这样子的RecordSet<p>: custom_id, name item ...<br>: ----------+------- +--------<br>: 001 AAA A01 <br>: 001 AAA A03 <br>: 001 AAA A04<br>: 002 BBB A02 <br>: 002 BBB B03<p>: <br>: 有没有辨法得到这样子的RecordSet<br>: custom_id, name item ...<br>: ----------+------- +--------------<br>: 001 AAA A01,A03,A04 <br>: 002 BBB A02,B03<p><br>看起来是 Hierarchical RecordSet的型态, 这种东东用<br>DataEnvironment 点几下就做好了, 不过要 VB6才可<br>以... vb6就要用 SubQuery来做, 而结果可以放在 FlexGrid<br>再合并 custom_id这个 column, 才不会出现许多 001,002
<br>
<br><hr size=7 width=75%><p>
<a name="followups">Follow Ups:</a><br>
<ul><!--insert: 15231-->
</ul><!--end: 15231-->
<br><hr size=7 width=75%><p>
</body></html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -