SQL Server - joining two tables

I have two table eg. fundtransfer and bankmaster. I have key of bankmaster twice in fundtransfer eg. tobank and frombank.

How can I write query to get both the names. If I use inner join then it giving only one name.

Thanks in advance.

Hi,

try this...

select a.bankName, b.bankName from fundtransfer c

inner join bankmaster a on c.fromBank = a.bankId

inner join bankmaster b on c.toBank = b.bankId

thanks but it is giving duplicate values should I use distinct?

thanks

It should fetch only one record but it is woring as cross job fundtransfer has only one record an it is giving mor ethan one record.

Thanks again

Getting more than one record corropoding to one record woring as cross join.

I am getting more than one record corrosponding to one record in the fundtransfer.

Plz help me

thanks

Hi

try this

select t1.bankName, t2.bankName from fundtransfer t3

LEFT OUTERjoin bankmaster t1 on t3.fromBank = t1.bankId

inner join bankmaster t2 on t3.toBank = t2.bankId

Thank you
http://www.codegain.com

Thanks a lot. Now its working properly. :)

Thanks

Hi,

you need to include some more unique columns in 'join condiontions'....