<div>
Tangent... &nbsp;Personally I *HATE* the ANSI join syntax. &nbsp;I find it much harder to read than the &quot;old&quot; join syntax. &nbsp;For this query, it's not bad but, as it gets more complex, the less I like ANSI joins.
</div>


Tangent...  Personally I *HATE* the ANSI join syntax.  I find it much harder to read than the "old" join syntax.  For this query, it's not bad but, as it gets more complex, the less I like ANSI joins.

<div>
Thanks guys! I ended up using the ANSI join syntax. <br />
<br />
left outer join dba.employee as es<br />
on es.empnum = header.whostart<br />
<br />
left outer join dba.employee as ec<br />
on ec.empnum = header.whoclose
</div>


Thanks guys! I ended up using the ANSI join syntax.

left outer join dba.employee as es
on es.empnum = header.whostart

left outer join dba.employee as ec
on ec.empnum = header.whoclose

<div>
<div class="content wysiwyg-content">
Hey guys,<br />
&nbsp;<br />
I have 2 tables using SyBase SQL Anywhere 10<br />
Employee Table<br />
EmpNum<br />
Firstname<br />
Lastname<br />
&nbsp;<br />
Sales Table<br />
Transact<br />
WhoStart (EmpNum)<br />
WhoClosed &nbsp; (EmpNum)<br />
&nbsp;<br />
I want to return the transaction number and the first name’s of the employee who started and closed the sale. Usually the person who starts and closes is the same, but sometimes it’s not.<br />
&nbsp;<br />
Help?
</div>
</div>


Hey guys,
 
I have 2 tables using SyBase SQL Anywhere 10
Employee Table
EmpNum
Firstname
Lastname
 
Sales Table
Transact
WhoStart (EmpNum)
WhoClosed   (EmpNum)
 
I want to return the transaction number and the first name’s of the employee who started and closed the sale. Usually the person who starts and closes is the same, but sometimes it’s not.
 
Help?

SyBase SQL Syntax

Sybase, a subsidiary of SAP, builds a client/server relational database management system. Products include Adaptive Server Enterprise (ASE), Adaptive Server Anywhere (ASA), Sybase Unwired Platform (SUP) for mobile applications, Afaria for enterprise mobile device management and IQ for data warehouse and big data applications.