Hi,,
I have a 4 tables need to join and retrieve the data...
Table 1
Tid - PK
Tname
a3
a4
a5
Table 2
Tid - FK
Tname
Lid-FK
Eid-FK
b3
b4
b5
Table3
Lid -PK
Lname
c3
c4
Table4
Eid - Pk
Ename
d2
d3
d4
...
10533
Last Activity: Jun 19 '10, 04:52 AM
Joined: Mar 12 '10
Location:
-
how to join 3 or more tables in sql server
-
Thank you, thats I understand, am new to C sharp coding
SO could you please explain me more clearly??
thanks. -
Object can not be cast from the DBNull to the other type errors
HI,
There are 2tables in the "mydatabse" .
1. Tools
2. ToolsRepair
there are some columns in the above two tables.
Toolid is the primary key of the Tools table and also FK for the ToolsRepair
and also there are some other columns in the two tables
I am trying to insert the all details of the ToolsRepair table using that FK_ Toolid
but...
No activity results to display
Leave a comment: