<div>
Looks to me like you're just missing the top part of the query. &nbsp;See this example, with a top query INNER JOINed to a subquery.<br />
<br />
<br />
SELECT p.Name, s.OrderQty<br />
FROM Production.Product p INNER JOIN ( &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SELECT ProductID, OrderQty <br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;FROM Sales.SalesOrderDetail) s <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ON p.ProductID = s.ProductID
</div>


Looks to me like you're just missing the top part of the query.  See this example, with a top query INNER JOINed to a subquery.


SELECT p.Name, s.OrderQty
FROM Production.Product p INNER JOIN (      SELECT ProductID, OrderQty
                                                                       FROM Sales.SalesOrderDetail) s
                                                                        ON p.ProductID = s.ProductID

<div>
Got it..In your example is Production the name of the database and product the name of the table
</div>


Got it..In your example is Production the name of the database and product the name of the table

<div>
Awesome..thanks for the reference also relative to the Objects !
</div>


Awesome..thanks for the reference also relative to the Objects !

<div>
<div class="content wysiwyg-content">
I was reviewing someone's SQL code within MS Excel that really has me puzzled. &nbsp;<br />
<br />
It shows:<br />
INNER JOIN(SELECT CUSTOMER.AC,&quot;,CUSTOMER.[Or<wbr />derDate]<br />
FROM CUSTOMER<br />
WHERE[Status]='Current' AS CLIENT<br />
ON....<br />
<br />
Can someone help me with whats going on relative to these lines ? &nbsp;Why is SELCT not its own line ?
</div>
</div>


I was reviewing someone's SQL code within MS Excel that really has me puzzled.  

It shows:
INNER JOIN(SELECT CUSTOMER.AC,",CUSTOMER.[OrderDate]
FROM CUSTOMER
WHERE[Status]='Current' AS CLIENT
ON....

Can someone help me with whats going on relative to these lines ?  Why is SELCT not its own line ?

Why do I see a SELECt within a Inner Join clauses

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.

VB Script

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.