主题：[求助]SQL语句问题

 列名加上表名。或者生成的时候，就记好每列对应的表。

用正则把{}的值取出来即可。但没有意义。

 

无法知道哪列来自哪个表的。

Dim str As String = "SE LECT 订购日期, {订单明细}.*, 产品名称 FROM ({订单明细} INNER JOIN {产品} ON {订单明细}.产品ID = {产品}.产品ID) INNER JOIN {订单} ON {订单明细}.订单ID = {订单}.订单ID ORDER BY 订购日期"
Dim mc = System.Text.RegularExpressions.Regex.Matches(str, "(?<=\{+).*?(?=\}+)")
Dim ls As New List(Of String)
For i As Integer = 0 To mc.count - 1
    If ls.Contains(mc(i).Value) = False Then
        ls.add(mc(i).Value)
        msgbox(mc(i).Value)
    End If
Next