RE: Help on joins please

2012-05-04 Thread Paul Newton
] 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

RE: Help on joins please

2012-05-04 Thread Dave Crozier
] 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

Re: Help on joins please

2012-05-04 Thread Ricardo Araoz
[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