table join loop query output advice and/or helPPP!

vaska

so close and so far away...trying to leaRNNN...

now...JOIN...i can't figure out the logic (query) of how i would use JOIN (left,inner,???) with a relation between two tables...

what i'm trying to do...joining table A and table B...where Aid=Bid...the data would roughly appear like this (there are two loops working here)...

the question...WILL JOIN help me do the below? or am i going in the wrong direction again?

thanks...jv

ps: any examples are much appreciated if anybody wants to try to query...

++++++++++++++++++++++++++++++
A1 - a.date,a.title,a.id

a.message

B1 - b.date,b.atitle,b.id (B1=A1)

b.message

B2 - b.date,b.atitle,b.id (B1=A1)

b.message

however many of times = number of Bid's
++++++++++++++++++++++++++++++
A2 - a.date,a.title,a.id

a.message

B3 - b.date,b.atitle,b.id (B2=A2)

b.message

B4 - b.date,b.atitle,b.id (B2=A2)

b.message

however many of times = number of Bid's
++++++++++++++++++++++++++++++++
however many of times = number of Aid's

twilson

jv,

I myself have never used a join, but I'm sure I should have somewhere along the way. Have you read the info at: http://sqlcourse2.com/joins.html? It's really good and may help. That's all that I can offer.

Hope it helps some,
Tom 🙂