November 8, 2007 at 5:57 am
Can you provide the DDL (create scripts) for the tables, or at least the relevant columns and their datatypes. Sample data would be nice too. 😉
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 5, 2007 at 4:29 am
u can use inner join in both table joins
December 5, 2007 at 4:34 am
derr?
(newbie)
I don,t understand...can you give example
December 14, 2007 at 11:04 am
select *
from table1
inner join table2 on table1.key = table2.key
inner join table3 on table1.key = table3.key
That's the SQL text. In Query Designer, I think you just drag the column from your third table onto the column from your first table (I haven't used a GUI for building a query in several years, and I think that's what you're trying to do here from what you wrote).
Does that help?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 4 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply