Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
asifbhura
Posting Yak Master
165 Posts |
 Posted - 2009-04-27 : 04:44:35
|
| Hi,I have two tables which is having records,Table1 is having these column id,foldername,createdate.Table2 is having fid,filename,createdate,file_ext,newname.Table1 is having 3 records which id is 9Table2 is having 4 records which fid is 9now i want to display total 7 record from both table which is id & fid is 9.How can i display,Regards, |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-04-27 : 05:03:13
|
| Use Union allMadhivananFailing to plan is Planning to fail |
 |
|
|
|
|
|
how to get records from both table....