var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: join from one table to another two tables
Hi to all, i am newbie to sql.
i just want to link one table to two another.
say i have 2 fields in Table A
3 fields in Table B
2 fields in Table C
now i want to show data from Table A
when INwardId is present at fileld TfrId will be NULL and vice versa
now i want to print InwardCode from Table B when InwardId is present in Table A and TfrDate from Table C when TfrId is present in Table A.
PLease help me !!!
pls guys, its urgent...
SELECT A.InwardID, B.InwardCode, A.TfrID, C.TfrDate
FROM #TableA as A
LEFT OUTER JOIN #TableB as B ON
A.InwardID = B.InwardID
LEFT OUTER JOIN #TableC as C ON
A.TfrID = C.TfrId
join from one table to another two tables
When you noticed that no one on this forum had answered your question within 9 minutes, you kindly reminded us how urgent this is to you. Nice .
jairaj.net pls guys, its urgent...
With kind regards . . . . . SQL Server 2000/2005/2012
Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2.
Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages
Thanks a Lot
Thanks a LOT WIM
Last edited by jairaj.net; 05-19-11 at 05:20.
Sorry just noticed the reply