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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 how to left join one table four times by another table ?

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 2000
i try to show
"1" ,"B","999","C","888","D","777",""

i use vb6.0 and access 2000
how 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.col

Sekar
~~~~
Success is not a destination that you ever reach. Success is the quality of your journey.
Go to Top of Page
   

- Advertisement -