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 |
|
veronika.np
Starting Member
29 Posts |
 Posted - 2011-02-12 : 17:23:38
|
| hi friendsi have a reservation number that it is unique.i want to search it in 3tables.my table field is different but all of them have reservation number.how can i find it.after that i want to show it in datagrid. |
|
|
MIK_2008
Master Smack Fu Yak Hacker
1054 Posts |
Posted - 2011-02-13 : 00:08:58
|
| can you come up with some sample data and the desired out of that same data ... This will help us to understand your problem and to help you out accordingly!! CheersMIK |
 |
|
|
yadhu_cse
Constraint Violating Yak Guru
252 Posts |
Posted - 2011-02-14 : 01:37:30
|
| use joins |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2011-02-14 : 04:06:09
|
| select TabName = '1', * from table1 where ReservationNumber = 15union all select TabName = '2', * from table2 where ReservationNumber = 15union all select TabName = '3', * from table3 where ReservationNumber = 15- LumbagoMy blog-> http://thefirstsql.com/2011/02/07/regular-expressions-advanced-string-matching-and-new-split-function-sql-server-2008-r2/ |
|
|
|
|
|
|
problem with this query