L
Lee Mundie
Hi,
Wondering if somebody can help me join these two statements to one!
The first looks at a tblMembers with tblBuddyList and matches the data by
Members.Author_ID and tblBuddyList.Buddy_ID etc.
really looking to get all the info in one; ultimately I want to check that
the tblBuddyList.Buddy_ID against tblActiveUser.Author_ID
to see if they match i.e. the user is online now
does that make sense! hope so, as my head suffered... lol
(1st Statement)
strSQL = "SELECT tblBuddyList.*, Members.Username, Members.Author_ID "
strSQL = strSQL & "FROM Members INNER JOIN tblBuddyList ON Members.Author_ID
= tblBuddyList.Buddy_ID "
strSQL = strSQL & "WHERE tblBuddyList.Author_ID=" & lngLoggedInUserID & "
AND tblBuddyList.Buddy_ID <> 2 "
strSQL = strSQL & "ORDER BY Members.Username ASC;"
(2nd statement)
strSQL = "FROM Members INNER JOIN tblActiveUser ON tblBuddyList.Buddy_ID =
tblActiveUser.Author_ID"
Will I have trouble diffentiating between the Member.Author_ID and
ActiveUser.Author_ID both being Author_ID - how could I get each value
seperately?
Thank in Advance...
Regards
Lee
Wondering if somebody can help me join these two statements to one!
The first looks at a tblMembers with tblBuddyList and matches the data by
Members.Author_ID and tblBuddyList.Buddy_ID etc.
really looking to get all the info in one; ultimately I want to check that
the tblBuddyList.Buddy_ID against tblActiveUser.Author_ID
to see if they match i.e. the user is online now
does that make sense! hope so, as my head suffered... lol
(1st Statement)
strSQL = "SELECT tblBuddyList.*, Members.Username, Members.Author_ID "
strSQL = strSQL & "FROM Members INNER JOIN tblBuddyList ON Members.Author_ID
= tblBuddyList.Buddy_ID "
strSQL = strSQL & "WHERE tblBuddyList.Author_ID=" & lngLoggedInUserID & "
AND tblBuddyList.Buddy_ID <> 2 "
strSQL = strSQL & "ORDER BY Members.Username ASC;"
(2nd statement)
strSQL = "FROM Members INNER JOIN tblActiveUser ON tblBuddyList.Buddy_ID =
tblActiveUser.Author_ID"
Will I have trouble diffentiating between the Member.Author_ID and
ActiveUser.Author_ID both being Author_ID - how could I get each value
seperately?
Thank in Advance...
Regards
Lee