Rookie SQL Question

[Ivan Sammut]

Hi,

This is a dump question most proably but totally fogot the SQL commands an
need a refresh. I have a table containing a list of cutomers (pcst), then I
have an other table (pcstmes) which contains some details about some of the
customer not all. The 2 tables are related by a fields named account.

I did an sql statment to select all the records from the the pcst and also
the records from pcstmes but somehow I am only getting those records which
have an entry in both tables. This is my SQL statment

"select pcst.name, pcst.tel, pcstmes.sline_1 from pcst,pcstmes where
pcst.Account= pcstmes.Account and pcst.Account = @sAcc"

I have something wrong in this line pcst.Account= pcstmes.Account
Anyone has an idea what I'm doing wrong.

Ivan

[Truong Hong Thi]

Let's use OUTER JOIN instead of INNER JOIN.

select pcst.name, pcst.tel, pcstmes.sline_1 from
pcst left join pcstmes on pcst.Account= pcstmes.Account
where pcst.Account = @sAcc

Thi

[Ivan Sammut]

Thanks it works fine

Ivan
"Truong Hong Thi" <th*****@gmail.com> wrote in message
news:11**********************@v46g2000cwv.googlegr oups.com...

Let's use OUTER JOIN instead of INNER JOIN.

select pcst.name, pcst.tel, pcstmes.sline_1 from
pcst left join pcstmes on pcst.Account= pcstmes.Account
where pcst.Account = @sAcc

Thi