<div>
Try this!<br />
<br />
Select Top &nbsp;1 Table1 .recID, &nbsp; Table2.RecID, &nbsp;Table2.Desc From Table1, Table2<br />
order by newid() --this for random
</div>


Try this!

Select Top  1 Table1 .recID,   Table2.RecID,  Table2.Desc From Table1, Table2
order by newid() --this for random

<div>
<div class="content wysiwyg-content">
Hi!<br />
<br />
Here's my problem: I have two tables.<br />
<br />
Table1:<br />
<br />
recID &nbsp; &nbsp; &nbsp; Description<br />
a &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; record a<br />
b &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; record b<br />
c &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; record c<br />
d &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; record d<br />
<br />
Table2:<br />
recID &nbsp; &nbsp; &nbsp; Table1RecID &nbsp; &nbsp; &nbsp; Description<br />
1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; a &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Record 1<br />
2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; a &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Record 2<br />
3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; a &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Record 3<br />
4 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; b &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Record 4<br />
5 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; b &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Record 5<br />
<br />
I would like to make a left join query, that would return ONLY ONE (can be random) record for every TABLE1 record FROM TABLE 2. Example:<br />
<br />
recIDTable1 &nbsp; &nbsp; &nbsp; &nbsp; RecIDTable2 &nbsp; &nbsp; &nbsp; &nbsp;DescTable2<br />
a &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Record2<br />
b &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Record4
</div>
</div>


Hi!

Here's my problem: I have two tables.

Table1:

recID       Description
a             record a
b             record b
c             record c
d             record d

Table2:
recID       Table1RecID       Description
1             a                       Record 1
2             a                       Record 2
3             a                       Record 3
4             b                       Record 4
5             b                       Record 5

I would like to make a left join query, that would return ONLY ONE (can be random) record for every TABLE1 record FROM TABLE 2. Example:

recIDTable1         RecIDTable2        DescTable2
a                         2                       Record2
b                         4                       Record4

JOIN Query that returns only the first record from every joined second table

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.