Select CaseNumber from tblParadox
Where CaseNumber = '011-281226'

Select CaseNumber from tblWebWhacker
Where CaseNumber = '011-281226'

Select CaseNumber from tblWebWhacker
Where Not Exists (Select CaseNumber From tblParadox)
Order by CaseNumber

Select CaseNumber from tblWebWhacker
Where Not Exists (Select * FROM tblParadox WHERE tblParadox.CaseNumber = tblWebWhacker.CaseNumber)
Order by CaseNumber

INSERT INTO tblCurrentMonth (CaseNumber) Values (Select CaseNumber from tblWebWhacker Where not exists (Select CaseNumber From tblParadox Where tblParadox.CaseNumber = tblWebWhacker.CaseNumber) And refund > 1000

quote:

---

Inserting a Row Using INSERT...Values
The VALUES keyword specifies the values for one row of a table. The values are specified as a comma-separated list of scalar expressions whose data type, precision, and scale must be the same as or implicitly convertible to the corresponding column in the column list. If a column list is not specified, the values must be specified in the same sequence as the columns in the table or view.

For example, this statement inserts a new shipper into the Shippers table using the VALUES clause:

INSERT INTO Northwind.dbo.Shippers (CompanyName, Phone)
VALUES (N'Snowflake Shipping', N'(503)555-7233')

A column list is required for this insert because the ShipperID column has the IDENTITY property; therefore, values cannot be inserted into it.

---

quote:

---

Inserting Rows Using INSERT...SELECT
The SELECT subquery in the INSERT statement can be used to add values into a table from one or more other tables or views. Using a SELECT subquery also lets more than one row be inserted at one time.

This INSERT statement inserts into a separate table some of the data from all the rows in titles whose type is modern cooking:

USE pubs
INSERT INTO MyBooks
SELECT title_id, title, type
FROM titles
WHERE type = 'mod_cook'

The select list of the subquery must match the column list of the INSERT statement. If no column list is specified, the select list must match the columns in the table or view being inserted into.

Another use of the INSERT...SELECT statement is to insert data from a source outside of Microsoft® SQL Server™. The SELECT in the INSERT statement can:

Reference a remote table on a linked server by using a four-part name. For more information, Identifying a Data Source Using a Linked Server Name.


Reference a remote table using OPENROWSET. For more information, see Identifying a Data Source Using the Ad Hoc Name.


Use the result set of a query executed on a remote server. For more information, see Using Pass-through Queries as Tables.

---