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.
For every expert, there is an equal and opposite expert. - Becker's Law
My blog
My TechNet articles
No comments:
Post a Comment