I don't know how you are connecting Emplyee(sic?) and Employment, but you want to use a join to connect two tables and in the join specify how the tables are related.  Joins usually look best when they have aliases so you don't have to repeat the entire table name.  The following query will get you all the information from both Employment and Distribution tables where the distribution location is equal to california.  You can join employee to employment to get name as well.


    SELECT *
    FROM Employment e
    JOIN Distribution d on d.DistributionID = e.DistributionID
    WHERE d.Location = 'California'


This will return the contents of both tables.  To select particular records use the alias.[Col_Name] separated by a comma in the select statement, like d.DistributionID to return the DistributionID from the Distribution Table

I am trying to use a second `SELECT` to get some ID, then use that ID in a second `SELECT` and I have no idea how.

    SELECT Employee.Name 
    FROM Emplyee, Employment 
    WHERE x = Employment.DistributionID 
    (SELECT Distribution.DistributionID FROM Distribution 
           WHERE Distribution.Location = 'California') AS x

**This post got long, but here is a short "tip"**

While the syntax of my select is bad, the logic is not. I need that "x" somehow. Thus the second `select` is the most important. Then I have to use that "x" within the first `select`. I just don't know how

**/Tip**

This is the only thing I could imagine, I'm very new at Sql, I think I need a book before practicing, but now that I've started I'd like to finish my small program.

**EDIT:**

Ok I looked up joins, still don't get it

    SELECT Employee.Name 
        FROM Emplyee, Employment 
        WHERE x = Employment.DistributionID 
        LEFT JOIN Distribution ON
        (SELECT Distribution.DistributionID FROM Distribution 
               WHERE Distribution.Location = 'California') AS x

Get error msg at `AS` and `Left`

I use name to find ID from upper red, I use the ID I find FROM upper red in lower table. Then I match the ID I find with Green. I use Green ID to find corresponding Name

![enter image description here][1]

I have `California` as output data from C#. I want to use `California` to find the DistributionID. I use the DistributionID to find the EmployeeID. I use EmployeeID to find Name

**My logic:**

    Parameter: Distribution.Name (from C#)

    Find DistributionID that has Distribution.Name
    Look in Employment WHERE given DistributionID 
          reveals Employees that I am looking for (BY ID)
    Use that ID to find Name
          return Name

Tables: 

**NOTE:** In this example picture the Employee repeats because of the select, they are in fact singular

In "Locatie" (middle table) is Location, I get location (again) from C#, I use `California` as an example. I need to find the `ID` first and foremost!

![enter image description here][2]


Sory they are not in english, but here are the create tables: 

![enter image description here][3]


  [1]: http://i.stack.imgur.com/SqgB6.jpg
  [2]: http://i.stack.imgur.com/LV4uO.png
  [3]: http://i.stack.imgur.com/6oQte.png

How to use the result from a second select in my first select

Yes, SQL Server **2012** supports multiple inserts - that feature was introduced in SQL Server **2008**.

That makes me wonder if you have Management Studio 2012, but you're really connected to a SQL Server **2005** instance ...

What version of the SQL Server **engine** do you get from `SELECT @@VERSION` ??

These StackOverflow questions [here][Q1], [here][Q2], and [here][Q3] all say the same thing, but I can't get it to run in SSMS or SQLFiddle



    CREATE TABLE #Names
      ( 
        Name1 VARCHAR(100),
        Name2 VARCHAR(100)
      ) 

    INSERT INTO #Names
      (Name1, Name2)
    VALUES
      ('Matt', 'Matthew'),
      ('Matt', 'Marshal'),
      ('Matt', 'Mattison')

When I execute this is SSMS, the insert fails with the following message on the first line after `VALUES`

> Msg 102, Level 15, State 1, Line 10    
> Incorrect syntax near ','.

This [**Fiddle**][fiddle] runs without the `#` sign, and the schema executes successfully when the table name is `#Names`, but I get the following message when I try to select * from the table 

> Invalid object name '#NAMES'.: SELECT * FROM #NAMES

Does SQL Server 2012 support multiple inserts?

----

**Update**: Apparently accessing a 2005 server on SSMS 2012....



    SELECT @@VERSION --Returns: Microsoft SQL Server 2005

    



 [Q1]: https://stackoverflow.com/questions/452859/inserting-multiple-rows-in-a-single-sql-query
 [Q2]: https://stackoverflow.com/questions/2676493/insert-multiple-rows-into-temp-table-with-one-command-in-sql2005
 [Q3]: https://stackoverflow.com/questions/2624713/how-do-i-insert-multiple-rows-without-repeating-the-insert-into-dbo-blah-part
 [fiddle]: http://sqlfiddle.com/#!18/32d8f/1

Insert Multiple Rows Into Temp Table With SQL Server 2012

These questions ([one][SO1], [two][SO2], [three][SO3]) all identified how to return an empty string instead of `NULL` *for a single column*:

    SELECT ISNULL(ColA,'') AS ColA FROM Table1

However, I have a query that returns a whole bunch of columns that I'm too lazy to select individually (don't worry - this isn't a production query)

    SELECT * FROM Table1

Is there a way to return an empty string for all columns returned by the wildcard operator?

For Example, the following naive attempt *won't work*:

    SELECT ISNull(*,'') FROM Table1

[SO1]: https://stackoverflow.com/q/21233442/1366033
[SO2]: https://stackoverflow.com/q/12394545/1366033
[SO3]: https://stackoverflow.com/q/17244808/1366033

Replace NULL with empty string in SQL for ALL columns

Here's the [full list of reserved keywords][2] broken up by color:

[![Reserved Keywords by Color][1]][1]

**Operators** (Grey)  

ALL, AND, ANY, BETWEEN, CROSS, EXISTS, IN, INNER, IS, JOIN, LEFT, LIKE, NOT, NULL, OR, OUTER, PIVOT, RIGHT, SOME, UNPIVOT

**System Functions** (Magenta)  

COALESCE, COLLATE, CONTAINS, CONVERT, CURRENT_TIME, CURRENT_TIMESTAMP, CURRENT_USER, NULLIF, SESSION_USER, SYSTEM_USER, TSEQUAL, UPDATE

**Keywords** (Blue)  

ADD, ALTER, AS, ASC, AUTHORIZATION, BACKUP, BEGIN, BREAK, BROWSE, BULK, BY, CASCADE, CASE, CHECK, CHECKPOINT, CLOSE, CLUSTERED, COLUMN, COMMIT, COMPUTE, CONSTRAINT, CONTAINSTABLE, CONTINUE, CREATE, CURRENT, CURRENT_DATE, CURSOR, DATABASE, DBCC, DEALLOCATE, DECLARE, DEFAULT, DELETE, DENY, DESC, DISK, DISTINCT, DISTRIBUTED, DOUBLE, DROP, DUMP, ELSE, END, ERRLVL, ESCAPE, EXCEPT, EXEC, EXECUTE, EXIT, EXTERNAL, FETCH, FILE, FILLFACTOR, FOR, FOREIGN, FREETEXT, FREETEXTTABLE, FROM, FULL, FUNCTION, GOTO, GRANT, GROUP, HAVING, HOLDLOCK, IDENTITY, IDENTITYCOL, IDENTITY_INSERT, IF, INDEX, INSERT, INTERSECT, INTO, KEY, KILL, LINENO, LOAD, MERGE, NATIONAL, NOCHECK, NONCLUSTERED, OF, OFF, OFFSETS, ON, OPEN, OPENDATASOURCE, OPENQUERY, OPENROWSET, OPENXML, OPTION, ORDER, OVER, PERCENT, PLAN, PRECISION, PRIMARY, PRINT, PROC, PROCEDURE, PUBLIC, RAISERROR, READ, READTEXT, RECONFIGURE, REFERENCES, REPLICATION, RESTORE, RESTRICT, RETURN, REVERT, REVOKE, ROLLBACK, ROWCOUNT, ROWGUIDCOL, RULE, SAVE, SCHEMA, SECURITYAUDIT, SELECT, SET, SETUSER, SHUTDOWN, STATISTICS, TABLE, TABLESAMPLE, TEXTSIZE, THEN, TO, TOP, TRAN, TRANSACTION, TRIGGER, TRUNCATE, UNION, UNIQUE, UPDATETEXT, USE, USER, VALUES, VARYING, VIEW, WAITFOR, WHEN, WHERE, WHILE, WITH, WRITETEXT


  [1]: https://i.stack.imgur.com/FgAzI.png
  [2]: https://learn.microsoft.com/en-us/sql/t-sql/language-elements/reserved-keywords-transact-sql?view=sql-server-2017

Microsoft SQL Management Studio highlights some special words coloring them in blue or in pink. I would like to know which rule determines the color to use.

For example, consider the two following statements:

    SELECT * FROM myTable
    UPDATE myTable SET myFlag = 'X'


[![SELECT * FROM myTable UPDATE myTable SET myFlag = 'X'][1]][1]

`UPDATE` is in pink while `SET`, `SELECT`, & `FROM` are in in blue.


  [1]: https://i.stack.imgur.com/DdgtY.png