用于从2个表中提取数据的SQL查询

Question

我一直在尝试编写一个查询，其中我将大部分信息放在一个表中，而只需要来自第二个表中一列的信息。两个表都有一个可用作连接的列。

但不幸的是，它没有给我想要的输出。我对编码比较陌生，使用PyPika编写我的查询。你能帮帮忙吗？

对于我知道有数据和许多重复日志的"workflowtracker.COE“，它给我五个”无“

请查找下面的查询

   q = Query.from_(workflowtracker).join(activitylog).on(
    activitylog.RequestId == workflowtracker.RequestId).select(workflowtracker.COE, activitylog.RequestId,
                                                               activitylog.SubjectLine,
                                                               activitylog.ResourceName, activitylog.ResourceEmail,
                                                               activitylog.GPN, activitylog.ExecutionDate,
                                                               activitylog.Status,
                                                               activitylog.TotalTimeTaken).where(
    (activitylog.Status == "In Progress") & (activitylog.ExecutionDate == excecutiondate))

Answer 1

请使用这个：

workflowtracker, activitylog = Tables('workflowtracker', 'activitylog')
q = Query
     .from_(workflowtracker)
     .join(activitylog)
     .on(workflowtracker.RequestId == activitylog.RequestId)
     .select(workflowtracker.COE, activitylog.RequestId,
               activitylog.SubjectLine,
               activitylog.ResourceName, activitylog.ResourceEmail,
               activitylog.GPN, activitylog.ExecutionDate,
               activitylog.Status,
               activitylog.TotalTimeTaken)
    .where(
    (activitylog.Status == 'In Progress') & (activitylog.ExecutionDate == excecutiondate)
    )