Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pharoah35
Yak Posting Veteran
81 Posts |
 Posted - 2007-09-28 : 13:13:18
|
| Good afternoonWell i'm back once again requesting asistance (Given that I have gotten expert assistance from this source), You guys are so helpful and you have my thanks in advance. Here's my new problem. I need to link 5 tables (details below)Table1:[SLS_INV_HDR] Table2:[SLS_INV_LNE]Field:[NO] --------------------------> Field: [DOC_NO]Table1:[SLS_INV_HDR] Table3:[SLS_LNE]Field:[ORDER_NO] --------------------> Field:[DOC_NO]Table3:[SLS_LNE] Table4:[PURCH_INV_HDR]Field:[PO_NO] ------------------------> Field:[ORDER_NO]Table3[SLS_LNE] Table4:[PURCH_INV_HDR]Field:[WH_PO_NO] ---------------------> Field:[ORDER_NO]Table4[PURCH_INV_HDR] Table5:PURCH_INV_LNE]Field:[NO] ---------------------------> Field:[DOC_NO]The "----->" Arrows represent the fields which need to be linked (they contain the same/matching values) I've tried MS Access Design View but just can't seem to get them linkled properly. Any assistance you can provide from a SQL syntax standpoint would be greatly appreciated. |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-09-28 : 14:45:54
|
| Can't you just JOIN then all together, just as you've drawn them, or is there some issue with that approach?Is this a SQL 200 problem, or an Access problem?Kristen |
 |
|
|
pharoah35
Yak Posting Veteran
81 Posts |
Posted - 2007-09-28 : 14:56:50
|
| Hi KristenThis is a SQL Database, (SQL 2000 SP4a)I've tried JOINING (Tried both INNER & OUTER JOIN) them together using SQL, then I tried using MS Access Design View to join them.But in both cases it isn't working.Eric |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-09-28 : 15:04:26
|
| Ah, I see. So you are OK with the JOIN syntax, just Access Design View isn't smart enough to go from there. Can't help further with that particular problem, sorry. |
|
|
|
gavakie
Posting Yak Master
221 Posts |
Posted - 2007-09-28 : 17:05:16
|
| Isnt working how? please elaborate. |
|
|
|
|
|
|
Linking multiple tables