Hi
I have 3 table.
Table1
StreamID int,
Stream Varchar,
Table2
PostStreamID int,
Stream Varchar,
Table3
UserID int
StreamID varchar(10),
PostStreamID varchar(10),
userName char(10)
Table1
-------------------------------------------
StreamID Stream
1 MCA
2 M.Tech
3 B.Tech
Table 2
-------------------------------------------
PostStreamID Stream
1 MA
2 Msc
3 Bsc
Table3
--------------------------------------
UserID StreamID PostStreamID userName
1 '1','2' '1','3' Jhon
2 '2','3' '2','3' Sachin
Now i want to join all the 3 table and fetch Stream and user name.How Can i do this? Please Help me.