|
|
| Author |
Message |
simone
Joined: 02 Mar 2004
Posts: 106
|
 Posted: 08/12/07 - 05:57 Post subject: |
 |
|
| Hello. I am beginner with SQL. Not only that, I am trying to create some SQL employee information query table. Three or more tables there will be. The one with the Employee information, the one with the Loans and the one with the Employee activities for now. As time is passing by, I will add more tables. How do I force drawing an empty filed in SQL to return to all customers without activities yet? Thanks in advance, because I am stuck here. |
|
|
Back to top
|
|
|
|
 |
adham
Joined: 22 Feb 2004
Posts: 123
|
| Posted: 09/24/07 - 21:04 Post subject: |
|
|
| Hi there. There are several ways to make SQL to do this. And I think that I do know one. I think that you can achieve your goal, by using a clause “not in”. You can just try to add this clause right after the employee ID for example. Please let me know what you did, because I am not sure my self about this too. |
|
|
Back to top
|
|
|
|
|
|
