Sunday, October 5, 2008

JOIN in SQL Data Manipulation Language

JOIN is a predicate in SQL's data manipulation language. This is primarily used in combining tables or relations to derive a new table.

We combine tables to create a query that will require information from more than one table.

Example of simple join query:

SELECT url.urlid, name, companyname
FROM url, company
WHERE url.urlid = company.companyurlid AND company.companyurldesc LIKE 'tayabas.ph'

I will post more on this topic later.

25 comments:

malcolm said...

hi sir, gud afternoon...
this is my SQL database..

Tekky said...

gud afternoon sir......

http://tekky-tekky.blogspot.com/

this is my sql statement using join data manipulaTion...

Unknown said...

here's my laboratory exercises in database and its output..., just click my blogger account in blogspot

http://hazelle0271.blogspot.com/

raineyen said...

elo gud aftrnoon sir.. this is my SQL database laboratory exercises..

http://raineyen.blogspot.com

tnx..:-)

JAYSON said...

gud eve sir....

this is my SQL database LAB EXERCISES..tnx!

arlene said...

heloo sir, her my sql database.
just click my blog sir.

arlene said...

helooo sir!!her my is project in advandb,.just click my blog!!
http://arlene28.blogspot.com

mary grace marin said...

hi sir I have done the meaning of RDBMS..



This is my URL http://gracecute14.blogspot.com

reymark said...

sir here's my assignment about RDBMS!
im reymark anthony capistrano!!
saintaine.blogspot.com

reymark said...

sir here's my assignment in RDBMS!!!

saintaine.blogspot.com

emjay said...

gud afternoon sir...
this is my rdbms assignment.
tnx

http://emjay20.blogspot.com/

Jeff said...

GOOD AFTERNOON PO,

ASSIGNMENT PO SA THEO DBS

http://jeffreyoabel.blogspot.com/

_Charish_ said...

hi! sir,
gud afternoon poh,,,
here's my aSs. in thEodBs..
thaNks poH...",

http://joanna-charish.blogspot.com/

aNgeL_piTiK said...

gud pm sir...
this is my RDBMS assignment...
god bless.
http://icol18.blogspot.com/

florebel said...

'hi!! sir...
gUd afternOon pOh...

herE's my asSignment in RDBMS...

http://florebelquililan.blogspot.com

Dutdutan said...

RDMBS... assignment...

gisela said...

pm sir...this is my RDBMS
..

http://gisela003.blogspot.com/

gisela said...

pm sir...this is my RDBMS
..

http://gisela003.blogspot.com/

A.K.K.I.N said...

hi sir..
this is my blog.. and dis is my RDBMS...

mlkin.blogspot.com...

edward said...

hi gud morning sir
this is my RDBMS

http://kaithlimit.blogspot.com/

aLdRiNe said...

sir? wazzup.. hehehe this is my RDBMS... thx.^_^
http://aldrine03.blogspot.com/

jopy aguiba said...

gud day sir..

here my definition of RDBMS..

http://aguibajopy.blogspot.com/

pamela said...

gud day sir...
this is my blog
http://naitx-1429.blogspot.com/
for THEODBS

Mariel said...

Good Lunch Time Sir...
this is my own blog that created just for our subject in THEODBS
http://marielpermante.blogspot.com/

shimozikato said...

i also have brief definition of RDBMS in my blog.

here's my url: http://rosanlinatoc.blogspot.com/