- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-02-2024 02:26 AM
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
Solved! Go to Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-02-2024 02:36 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-02-2024 02:36 AM
Hi Patricia,
Try something as below.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-11-2024 06:32 AM
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-02-2024 02:40 AM