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.

28 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...

hazelle 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..:-)

thikhaye said...

gud eve sir....

this is my SQL database LAB EXERCISES..tnx!

papa JOey.. said...

A very pleasant day to you sir!

Apparently, I have finished creating, modifying and testing the databases that you are requiring us, BSCS331, to be specific, sceduled during Thursday (2:30-5:30) and Friday(10-1).

In line with this, my work also includes the assignment regarding about a query foreseeing an ODD numbered inventory.

Please see my work, http://www.jlpatrick.blogspot.com

Thank you and Godspeed sir!

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

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 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

Ormond Anielsanto said...

hi sir....
nice blog of yours!!!..
by the way my blog is http://mond24.blogspot.com/
just check it out...
it content my ass. in THEODBMS...

micomics 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...

johnson said...

hi sir..
i have already make my ass.
this is mu URL: http://johnsonhuelba.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/