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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
Posted - 2003-09-24 : 07:50:05
|
| Jesse writes "ive tow table like these below records of table a "1" ,"eab" ,"999" , "eac" ,"888" ,"ead","777","eae" records of table b "eab" ,"B" "eac" , "C" "ead" ,"D"i use vb6.0 and access 2000i try to show "1" ,"B","999","C","888","D","777",""i use vb6.0 and access 2000how to set my sql string by left join or right join?" |
|
|
samsekar
Constraint Violating Yak Guru
437 Posts |
Posted - 2003-09-24 : 08:02:57
|
| HTH..select a.col, b.col from a right outer join b group by a.col, b.colSekar~~~~Success is not a destination that you ever reach. Success is the quality of your journey. |
 |
|
|
|
|
|
|
|