] On
Behalf Of Sytze de Boer
Sent: 04 May 2012 06:15
To: profoxt...@leafe.com
Subject: Help on joins please
In a routine of mine, I do the following and all is fine select pcode as Code,
pemp.name, gross,tax,nontgross as Non_Taxables ,deductions from palldets ;
join pemp on palldets.pcode=pemp.code
] On Behalf Of
Paul Newton
Sent: 04 May 2012 09:17
To: profox@leafe.com
Subject: RE: Help on joins please
Sytze
You need two select statements with a union like this
Select . Union (Select .)
The first select will refer to pemp and the second select refers to pempex
Paul
[mailto:profox-boun...@leafe.com] On Behalf Of
Paul Newton
Sent: 04 May 2012 09:17
To: profox@leafe.com
Subject: RE: Help on joins please
Sytze
You need two select statements with a union like this
Select . Union (Select .)
The first select will refer to pemp and the second
3 matches
Mail list logo