iki loh syntax keeee
SELECT [tablename.]fieldname [,[tablename.]fieldname ...] FROM tablename
INNER JOIN tablename2 ON tablename.fieldname = tablename2.fieldname2
Parameters
fieldname
Specifies the name of a field in the table to include in the recordset.
tablename
Specifies the name of the table from which to retrieve data
contoh :
SELECT CategoryName, ProductName
FROM Categories INNER JOIN Products
ON Categories.CategoryID = Products.CategoryID;
kalo bingung buka aja ke msdn.microsoft.com, cari dengan kata kunci "select
join"
----- Original Message -----
From: Ibnu Rizal <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, October 10, 2000 11:12 AM
Subject: Re: [MasterWeb] Menampilkan dua tabel di ASP?
> Oh iya Mas, tapi setelah saya cari tahu di help-nya Access, saya masih
nggak
> nemuin cara joinnya, dia hanya ngasih tahu options join aja. Bagaimana
> caranya?
> Sorry nih kalau cerewet nanya-nya.
>
>
> Regards,
> Ibnu Rizal
> www.myrizal.com
>
> ----- Original Message -----
> From: Bambang Hermanto <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, October 10, 2000 10:53 AM
> Subject: Re: [MasterWeb] Menampilkan dua tabel di ASP?
>
>
> > kalo ternyata kedua table berhubungan, kenapa tidak di JOIN....
> >
> >
> > ----- Original Message -----
> > > >
> > > > Ikutilah lomba banner flash berhadiah :
> > > > http://www.master.web.id/kreasi-banner-berhadiah.htm
> > > >
> > > > -------[ Master Web Indonesia - www.master.web.id ] -------
> > > > Moderator : [EMAIL PROTECTED]
> > > > Berlangganan : [EMAIL PROTECTED]
> > > > Stop Berlangganan : [EMAIL PROTECTED]
> > > > -----------------------------------------------------------
> > > >
> > >
> > >
> > >
> > > Ikutilah lomba banner flash berhadiah :
> > > http://www.master.web.id/kreasi-banner-berhadiah.htm
> > >
> > > -------[ Master Web Indonesia - www.master.web.id ] -------
> > > Moderator : [EMAIL PROTECTED]
> > > Berlangganan : [EMAIL PROTECTED]
> > > Stop Berlangganan : [EMAIL PROTECTED]
> > > -----------------------------------------------------------
> > >
> >
> >
> >
> > Ikutilah lomba banner flash berhadiah :
> > http://www.master.web.id/kreasi-banner-berhadiah.htm
> >
> > -------[ Master Web Indonesia - www.master.web.id ] -------
> > Moderator : [EMAIL PROTECTED]
> > Berlangganan : [EMAIL PROTECTED]
> > Stop Berlangganan : [EMAIL PROTECTED]
> > -----------------------------------------------------------
> >
>
>
>
> Ikutilah lomba banner flash berhadiah :
> http://www.master.web.id/kreasi-banner-berhadiah.htm
>
> -------[ Master Web Indonesia - www.master.web.id ] -------
> Moderator : [EMAIL PROTECTED]
> Berlangganan : [EMAIL PROTECTED]
> Stop Berlangganan : [EMAIL PROTECTED]
> -----------------------------------------------------------
>
Ikutilah lomba banner flash berhadiah :
http://www.master.web.id/kreasi-banner-berhadiah.htm
-------[ Master Web Indonesia - www.master.web.id ] -------
Moderator : [EMAIL PROTECTED]
Berlangganan : [EMAIL PROTECTED]
Stop Berlangganan : [EMAIL PROTECTED]
-----------------------------------------------------------
