<div>
What about just joining the tables on that cust_no field?<br />
<br />
Something like:<br />
<br />
<br />
<br />

<pre><code id="code-36262">
SELECT a.cust_no, a.sales, b.sales, c.sales
FROM tablea a
JOIN tableb b on a.cust_no = b.cust_no
JOIN tablec c on b.cust_no = c.cust_no
</code></pre>
</div>


What about just joining the tables on that cust_no field?

Something like:






SELECT a.cust_no, a.sales, b.sales, c.sales
FROM tablea a
JOIN tableb b on a.cust_no = b.cust_no
JOIN tablec c on b.cust_no = c.cust_no


<div>
gnar:<br />
The cust_no doesn't exist in all tables. &nbsp;I need have a column that has all the cust_no's whatever table they're in and then place a zero dollars in the sales part where they don't exist.
</div>


gnar:
The cust_no doesn't exist in all tables.  I need have a column that has all the cust_no's whatever table they're in and then place a zero dollars in the sales part where they don't exist.

<div>
WOW! &nbsp;Excellent script. &nbsp;Thanks and I'm on my way!
</div>


WOW!  Excellent script.  Thanks and I'm on my way!

<div>
<div class="content wysiwyg-content">
Not sure if this is &quot;so-able.&quot;<br />
<br />
I have three tables with sales information in them.<br />
<br />
Each table has a &quot;cust_no&quot; field, year, sales.<br />
<br />
How do I write a view that has<br />
Customer &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;TY Sales &nbsp; &nbsp; &nbsp;SalesYR-1 &nbsp; SalesYR-2<br />
1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;200 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 100 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0<br />
2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 200 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0
</div>
</div>


Not sure if this is "so-able."

I have three tables with sales information in them.

Each table has a "cust_no" field, year, sales.

How do I write a view that has
Customer          TY Sales      SalesYR-1   SalesYR-2
1                          200               100                  0
2                             0                   200              0

SQL Server view

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.