如何写KSQL语句？

zhaixin

在ksql中主键使用概念的别名表示，另外概念名、关系名大小写敏感
select *
    from Tbl_edu_cust Tbl_edu_cust
    join Tbl_educuststate Tbl_educuststate on Tbl_edu_cust = Tbl_educuststate.fLinkManID
    where Tbl_educuststate.fContactTime = (
     select max(fContactTime)
    from Tbl_educuststate t2 where t2.fLinkManID = Tbl_edu_cust )

hxqsys

hxqsys 发表于 2013-9-16 15:56
select *
    from Tbl_edu_cust t1
    join Tbl_educuststate t3 on t1.fID = t3.fLinkManID

问题已通过远程解决，谢谢了.

hxqsys

问题已远程解决，谢谢，可以结贴。
正确的KSQL：
select Tbl_edu_cust.*,(select  max(Tbl_eduCustState.fContactTime) from Tbl_eduCustState Tbl_eduCustState  where Tbl_eduCustState.fLinkManID = Tbl_edu_cust) as fContactTime
    from Tbl_edu_cust Tbl_edu_cust
    where Tbl_edu_cust in (select  Tbl_eduCustState.fLinkManID from Tbl_eduCustState Tbl_eduCustState)