<div>
<div class="content wysiwyg-content">
hi all i have two tables as follow:<br />
<br />
Table A:<br />
A_ID &nbsp;A_Name OrdeNo<br />
1 &nbsp; &nbsp; &nbsp; &nbsp;JAD &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1<br />
2 &nbsp; &nbsp; &nbsp; &nbsp;Samir &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2<br />
<br />
Table B:<br />
B_ID &nbsp;B_Name OrderNo &nbsp;Amount &nbsp;Date<br />
1 &nbsp; &nbsp; &nbsp; jean &nbsp; &nbsp; &nbsp; &nbsp; 1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 20 &nbsp; &nbsp; &nbsp;10/10/2010 <br />
1 &nbsp; &nbsp; &nbsp; Khalil &nbsp; &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 30 &nbsp; &nbsp; &nbsp;10/10/2011 &nbsp; <br />
<br />
I want to join the two tables to get as out put:<br />
A_ID &nbsp; &nbsp;A_Name &nbsp; &nbsp;Date <br />
<br />
but the problem is the join between the two tables is basic according to OrderNo of Max(Amount).<br />
<br />
Please advice.<br />
<br />
Regards,
</div>
</div>


hi all i have two tables as follow:

Table A:
A_ID  A_Name OrdeNo
1        JAD              1
2        Samir           2

Table B:
B_ID  B_Name OrderNo  Amount  Date
1       jean         1                 20      10/10/2010 
1       Khalil        1                 30      10/10/2011   

I want to join the two tables to get as out put:
A_ID    A_Name    Date 

but the problem is the join between the two tables is basic according to OrderNo of Max(Amount).

Please advice.

Regards,

special join+ms sql server 2005

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.