Need to convert SQL Server statement to Progress SQL-92

[kamikazeniel]

Hi guys, i need to convert this SQL statement to SQL-92.


select
a.User_PID as User_PID,
a.Int_Data1 as Door_ID,
a.Local_DT as TimeInOut,
a.Int_Data2 as BadgeCd,
'Web Service' as CreateUserID,
getdate() as CreateDate
from dbo.journ as a

inner join (select c.User_pid, Max(c.Local_DT)as Timer from dbo.journ as c where c.msg_code = 2 group by c.user_pid ) as b
on a.User_pid = b.User_pid and a.Local_DT = b.Timer

I can't run this in Progress DB. I believe the problem is with this statement "a.Local_DT = b.Timer".

 

[kamikazeniel]

Now I got the solution...
thanks for not replying

select
a.User_PID as User_PID,
a.Int_Data1 as Door_ID,
a.Local_DT as TimeInOut,
a.Int_Data2 as BadgeCd,
'Web Service' as CreateUserID,
sysdate() as CreateDate
from pub.journ as a
inner join (select c.User_pid as userid, Max(c.Local_DT)as Timer from pub.journ as c where c.msg_code = 2 group by c.user_pid ) as b
on a.User_pid = Userid and a.Local_DT = Timer

 

[Casper]

thanks for not replying

thank you for not paying us
My guess is that either nobody found the time to look at your problem or there was nobody who knew the answer....

But anyway very goods sports of you to send the follow up :up:

Casper

 

[tamhas]

So, was your problem dbo versus pub or the b.Timer instead of Timer or both?