title: Query Code Joining Issues
body: <p><a href="http://i.stack.imgur.com/1zTAo.png" rel="nofollow">Final Query Table</a> - What the final table should look like.
  <a href="http://i.stack.imgur.com/e8CCw.png" rel="nofollow">Pubs Tables</a> - I did not include the author_id which needs to be changed to SSN. </p>
  
  <p>I am very new to this - like three weeks into this class. I'm struggling to wrap my brain around the concepts but it looks like there is a wealth of information on stack overflow I need to keep reading....it would help if I were actually using a database on a regular basis in a real life situation right now. Here is my query I keep coming up with an error on - possible I am making beginner mistakes I'm not seeing or understanding. I want to understand and get this down before it gets harder. </p>
  
  <pre><code>USE pubs
  SELECT DISTINCT authors_id as SSN
  FROM authors
  SELECT au_lname, au_fname as fullname
  FROM authors
  INNER JOIN author
  WHERE royalsched = &lt;50
  </code></pre>
  
  <p>I'm getting an error message - incorrect syntax near the word where, msg 156, level 15 state 1 line 7</p>
  
  <p>The question is: Select the unique author id as ssn, the lastname and firstname separated by a comma (smith, joe) as Fullname from the authors table joined on the titleauthor table where the royaltyper is less than 50. Order the query by the fullname. I get that I need to append the values of the fields together (concatenate) by using the + symbol and I know that I need to join them - just not sure if I'm headed in the right direction or not. Is there a place you can check your queries like validator online (to show where you've missed stuff?) </p>
  
  <p><strong>Update 10/6/16:</strong> 
  Tried it again. This is my reasoning: join the tables (INNERJOIN?) bring together the first name and last name (field 1 + field 2) althoughthis is where you were saying I need to do something different. This is what I came up with but it is not working: (authors_id is what it is called in the database so it needs to be changed to SSN, au_lname and au_fname need to be combined into one column as FullName) then it needs to show the royaltyper is less than 50.   </p>
  
  <p>SELECT authors_id = SSN FROM authors AS INNER JOIN ON au_lname + au_fname WHERE royaltyper = &lt;50  </p>