1)
SELECT pr_employee.employee_id, pr_employee.payment_period,
pr_employee.payment_take_home
FROM pr_employee
WHERE (((pr_employee.payment_period)=2)) OR
(((pr_employee.payment_period)=10));
2)
SELECT pr_employee.employee_id, pr_employee.payment_period,
pr_employee.payment_take_home
FROM pr_employee
WHERE (((pr_employee.payment_period) Between 2 And 10));
aksan kurdin
yokananwahyono wrote:
Month dan yearnya berupa number
Oya tablenya pr_monthly_salary
Sudah saya otak- atik kok blm bisa
------------------------------------------------------------------------
*From:* [email protected]
[mailto:[email protected]] *On Behalf Of
*[email protected]
*Sent:* Friday, January 29, 2010 10:25 AM
*To:* [email protected]
*Subject:* [belajar-access] Re: table join dengan table itu sendiri syntac
Bpk, Period dan Year itu jenisnya Text? Biasanya kalau jenis Number
bisa langsung dibuat criteria: Between [Bln1] And [Bln2]. Atau bila
ingin bulan tertentu, criteria: month=[Bln1] And month=[Bln2].
Thank's.
--- In [email protected]
<mailto:belajar-access%40yahoogroups.com>, "yokananwahyono"
<yokananwahy...@...> wrote:
>
> Dear para Ahli
>
>
>
> Saya memiliki table "pr_employee" yg berisi
>
> Employee_id,payment_period,month,year,Payment_take_home
>
>
>
> 1 saya ingin tau orang yg mendapat gaji feb dan gaji nov kuncinya yaitu
> payment period
>
> Join table dengan table itu sendiri caranya gmn y
>
> Saya pakai kode ini kok tdk bisa y? tlng di koreksi
>
>
>
> select employee_id
>
> from
>
> ((select a.employee_id
>
> from pr_employee a
>
> where a.payment_period='2' and
>
> a.year='2009') as feb) inner join
>
> ((select b.employee_id
>
> from pr_employee b
>
> where b.payment_period ='10' and
>
> b.year ='2009') as oct )
>
> sep.employee_id = oct.employee_id
>
>
>
> 2 saya ingin tau karyawan yang mendapat gaji dari bulan 2-10 kodenya
gmn y?
>
>
>
> Thx
>
>
>
> wahyono
>
