Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mcupryk
Yak Posting Veteran
91 Posts |
 Posted - 2011-04-10 : 22:05:03
|
| deleted |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2011-04-10 : 22:10:52
|
"What is the difference between inner and outer left join."in short INNER JOIN will return records that exists in both side of the join tableLEFT OUTER JOIN will return records from left side of table regardless of it exists or not in the right side of the join."Listing of all the records for an employer separated into Labour file,Certificates, Collective Agreements, First Contracts, Arbitration Awards, and Written Reasons."Not really sure what do you want here. Can post some sample data and the expected result ?
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2011-04-10 : 22:54:06
|
What exactly do you want to achieve here ?Do you have problem with the existing query ?
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
|
|
|
Global Employer