Click here to Skip to main content
15,877,573 members
Home / Discussions / Database
   

Database

 
AnswerRe: what is the equivalent linq query for the following sql query? Pin
Dhyanga7-Nov-14 7:44
Dhyanga7-Nov-14 7:44 
Questionmigrate a database in informix server to a local server mysql or postgree Pin
Ibrahim.elh6-Nov-14 3:48
Ibrahim.elh6-Nov-14 3:48 
AnswerRe: migrate a database in informix server to a local server mysql or postgree Pin
Eddy Vluggen7-Nov-14 7:33
professionalEddy Vluggen7-Nov-14 7:33 
QuestionSQL Left Outer Join Problem Pin
Vimalsoft(Pty) Ltd4-Nov-14 21:53
professionalVimalsoft(Pty) Ltd4-Nov-14 21:53 
AnswerRe: SQL Left Outer Join Problem Pin
Vimalsoft(Pty) Ltd4-Nov-14 22:11
professionalVimalsoft(Pty) Ltd4-Nov-14 22:11 
GeneralRe: SQL Left Outer Join Problem Pin
Mycroft Holmes4-Nov-14 22:33
professionalMycroft Holmes4-Nov-14 22:33 
GeneralRe: SQL Left Outer Join Problem Pin
Vimalsoft(Pty) Ltd4-Nov-14 22:34
professionalVimalsoft(Pty) Ltd4-Nov-14 22:34 
AnswerRe: SQL Left Outer Join Problem Pin
Richard Deeming5-Nov-14 1:42
mveRichard Deeming5-Nov-14 1:42 
Two rows would be the expected result for a LEFT JOIN with that data.

Each row from the table on the left will be returned once for each matching row in the table on the right, or once if there are no matching rows. Since the table on the right only has two rows, and the table on the left only has one row, the result will be two rows.

Jeff Atwood has a good visual explanation of SQL joins:
http://blog.codinghorror.com/a-visual-explanation-of-sql-joins/[^]

Another way to explain joins:
  • Product the Cartesian Product of the two tables - each row in the left-hand table is matched with each row in the right-hand table.
  • Remove the rows where the JOIN condition is not met.
  • Depending on the JOIN type:

    • INNER JOIN: Nothing to do.
    • LEFT (OUTER) JOIN: Any rows in the left-hand table but not in the results are added back, matched with a row of NULL values for the right-hand table.
    • RIGHT (OUTER) JOIN:: Any rows in the right-hand table but not in the results are added back, matched with a row of NULL values for the left-hand table.
    • FULL (OUTER) JOIN: Apply the rules for both LEFT and RIGHT joins.
  • Filter the result based on the conditions in the WHERE clause (if any).




"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer


SuggestionMessage Closed Pin
3-Nov-14 12:07
Member 24194273-Nov-14 12:07 
GeneralRe: New SQLite Management Program Pin
PIEBALDconsult3-Nov-14 12:48
mvePIEBALDconsult3-Nov-14 12:48 
QuestionSSRS across Internet Pin
JM7631-Oct-14 6:52
JM7631-Oct-14 6:52 
QuestionRe: SSRS across Internet Pin
GuyThiebaut3-Nov-14 1:43
professionalGuyThiebaut3-Nov-14 1:43 
AnswerRe: SSRS across Internet Pin
JM763-Nov-14 5:52
JM763-Nov-14 5:52 
GeneralRe: SSRS across Internet Pin
GuyThiebaut3-Nov-14 6:12
professionalGuyThiebaut3-Nov-14 6:12 
GeneralRe: SSRS across Internet Pin
Eddy Vluggen3-Nov-14 8:14
professionalEddy Vluggen3-Nov-14 8:14 
GeneralRe: SSRS across Internet Pin
JM765-Nov-14 0:25
JM765-Nov-14 0:25 
GeneralRe: SSRS across Internet Pin
JM7610-Nov-14 6:02
JM7610-Nov-14 6:02 
GeneralRe: SSRS across Internet Pin
Eddy Vluggen10-Nov-14 8:12
professionalEddy Vluggen10-Nov-14 8:12 
GeneralRe: SSRS across Internet Pin
JM7610-Nov-14 8:23
JM7610-Nov-14 8:23 
GeneralRe: SSRS across Internet Pin
Eddy Vluggen11-Nov-14 0:31
professionalEddy Vluggen11-Nov-14 0:31 
GeneralRe: SSRS across Internet Pin
JM7611-Nov-14 6:58
JM7611-Nov-14 6:58 
GeneralRe: SSRS across Internet Pin
Eddy Vluggen11-Nov-14 7:52
professionalEddy Vluggen11-Nov-14 7:52 
GeneralRe: SSRS across Internet Pin
JM7612-Nov-14 20:56
JM7612-Nov-14 20:56 
GeneralRe: SSRS across Internet Pin
Eddy Vluggen13-Nov-14 5:41
professionalEddy Vluggen13-Nov-14 5:41 
QuestionSSIS package Pin
Sachin Malviya31-Oct-14 6:01
Sachin Malviya31-Oct-14 6:01 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.