p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   SQL Server 2000 (http://p2p.wrox.com/forumdisplay.php?f=20)
-   -   What are joins? (http://p2p.wrox.com/showthread.php?t=59600)

Bhalchandra June 29th, 2007 10:20 PM

What are joins?
I know this is a very basic question but in my last interview, interviewer asked me to define join and replied him that
join can retrieve data from two or more tables based on logical relationships between the tables

But he did not satisfied with answer.
So please any body can give me exact definition of join
Is my definition of 'Join' is correct or need some modification?


Jeff Moden June 30th, 2007 12:25 AM

Sounds like he was being a little picky (a LOT, actually) but he might have been looking for something like this...

Joins indicate how the server should use data from one table to select the rows in another table.


A join condition defines the way two tables are related in a query.

The oh-so-subtle difference is that in your definition, you stipulated they were to "retrieve data"... not necessarily true... joins could be used "in a query" just to identify which rows of a table should be updated with a constant (for example). Not all "queries" are SELECTs...

Like I said, though... whoever the interviewer was, he was being really picky... I'd have been tempted to ask him what 2 to the zero power is or what 14 base 16 in decimal is just to get revenge on being so picky :D

Consider this... if he's going to be THAT picky, you probably didn't want to work there, anyway... guy sounds like a jerk.

--Jeff Moden

Jeff Moden July 2nd, 2007 11:29 PM

Any feedback? Maybe even a thanks?

--Jeff Moden

All times are GMT -4. The time now is 07:47 PM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.