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 |
|
Kujanator
Starting Member
1 Post |
 Posted - 2015-04-09 : 05:34:08
|
| Hi, I've got two tables and I want to get the LecturerName and LecturerID from lecturers who are teaching one or more units. I think I might need to join the tables but I'm not sure? Here's the code if anyone could have a look, http://sqlfiddle.com/#!9/958f1 |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2015-04-09 : 08:36:49
|
| Hmmm...looks like homework to me. You need to make an attempt. Post your query if it doesn't work correctly. Yes, you need to join the tables. |
 |
|
|
|
|
|
Simple query using two tables.