How to link tables to create database view

PatriciaA987250
Tera Expert

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

1 ACCEPTED SOLUTION

Jaspal Singh
Mega Patron
Mega Patron

Hi Patricia,

Try something as below.

JaspalSingh_0-1719912962027.png

 

View solution in original post

3 REPLIES 3

Jaspal Singh
Mega Patron
Mega Patron

Hi Patricia,

Try something as below.

JaspalSingh_0-1719912962027.png

 

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?