Help me with JOIN?? 1

[Dorine]

I would like to join to tables. I would like to see all the data from table a and only the data from table f which corresponds with table a. I thought a left join would be the solution but I still get all the data from the two tables. I have read the paper on joins but I know I am doing something wrong. Please help!

select * from dbo.PRSEBA a
left join dbo.PFFTPR f on a.ZZCLNR = f.TFCLNR

 

[swampBoogie]

You need an inner join

select * from dbo.PRSEBA a
join dbo.PFFTPR f on a.ZZCLNR = f.TFCLNR

not a left outer join.

 

[Dorine]

Thanks swampBoogie