|
Xaris
Starting Member
Cyprus
2 Posts |
 Posted - 12/06/2012 : 09:27:05
|
I have two tables:
Table1:
RFIDtag Title Author Description Image ShelfNumber
2 CalculusI whatever whatever bytes 1
3 CalculusII whatever whatever bytes 1
Table2:
RFIDtag ANTENNa
1 1
2 1
3 1
4 1
5 1
6 1
I want to check if these tables have a common RFIDtag
and then display a table with the common RFIDtags,Title,author,description,image and add the column antenna from the 2nd table to the corresponding RFIDtag |
|
|
nigelrivett
Flowing Fount of Yak Knowledge
United Kingdom
3328 Posts |
Posted - 12/06/2012 : 09:33:36
|
select t1.RFIDtag,Title,author,description,image,antenna
from Table1 t1
join table2 t2
on t1.RFIDTag = t2.RFIDTag
==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy. |
 |
|
PROBLEM
