database view

[nameisnani]

Hi Team 

Please help me here ,

I want to merge two tables 

1. sys_user_has_license_list

2. sys_user 

From the user table i have to bring Last login time - to ' (sys_user_has_license )

I have created database view , I think there was an error in ' where caluse ' can any one please help me here

what should i update in where clause

Thanks in advance  

[Amit Verma]

Hi @nameisnani 

Couple of observations :

1. User is a reserved keyword so please don't use it as variable prefix.

2. Also, in the where clause, "us" alone will not work as you need to provide the field name from the table as well to get the value (Like sys_id of the user record).

Please try the below configuration and see if it works :

Thanks and Regards

Amit Verma

[Bhavya11]

Hi @nameisnani 

As you mention from the user table i have to bring Last login time and need to compare with created because there is no suitable field that match last login time

If I could help you with your Query then, please hit the Thumb Icon and mark as Correct !!

Thanks

BK