Tuesday, April 1, 2014

Joining SQL Tables

If these tables have a column (or columns) that can be used for joining, then simply use JOIN syntax, e.g.


select A.Col1, A.Col2, B.Col3


from TableA A INNER JOIN TableB B ON A.Col1 = B.Col1


----------------------


Take a look at the course in www3schools, e.g.


http://ift.tt/1bU0GxG




For every expert, there is an equal and opposite expert. - Becker's Law





My blog




My TechNet articles


No comments:

Post a Comment