and another table with the data saved for each form with the columns
FormID | ClientID | ClientFormID | EmplID | Completed
1 1901 1 2 Yes
2 1901 2 2 Yes
3 1901 3 3 Yes
4 1901 2 3 Yes
5 1905 6 4 Yes
6 1905 7 4 Yes
I need to query both tables to show the forms belonging to the client for a specific employee and show whether or not the employee has completed the form. My problem is that id the employee has not yet completed the form, the record does not exist on the FormsData table.
The results I need to show if employe with id 2 and clientid 1901 are as follows
Name | Description | Completed
Form1 Des1 Yes
Form2 Des2 Yes
Form3 Des3 No
Form4 Des4 No
Form5 Des5 No
Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.
Why is this different from all of the other step by step guides? Because I make a living as a DBA and not as a writer and I lived through this experience.
Defining the name:
When I talk to people they say different names on this subject stuff l…