How to link tables to create database view

[PatriciaA987250]

Hi,

I would like to create a database view in order to create a report. I want to pull data from tables below. Please advice how to join these tables.

- time_card

-time_card_daily

-pm_project

Thank you

[Jaspal Singh · Accepted solution]

Hi Patricia,

Try something as below.

[PatriciaA987250]

Thank you for the feedback. It worked well. Just that intead of timecard.sys_id i used timecard_sys_id. Would like to confirm with you, would with dot (timecard.sys_id) will work as well?

[Harish Bainsla]

HI @PatriciaA987250  check below video 

https://youtu.be/VmxDIxFQv7c?si=OV6SXVAJWrqepXL8