Hi guys, I am trying to learn more about joins, so this is just a few tables I threw together to learn with. That's why the table names andcolumn names are so simple...

I am trying to pull info from three tables.. I am first trying to get the sql statement to work before moving on to displaying data. This is giving me the following message...

Syntax error (missing operator) in query expression 'a.b_id = b.b_id JOIN c ON b.c_id = c.c_id'.

Here is my code:

 
<%
strQ = "SELECT a_name, a_id, a.b_id, a.c_id, b.c_id, b.b_name, c.c_name FROM a"
strQ = strQ & " INNER JOIN b"
strQ = strQ & " ON a.b_id = b.b_id"
strQ = strQ & " JOIN c"
strQ = strQ & " ON b.c_id = c.c_id;"
 
objRS.Open strQ
%>

any help is much appreciated...

Thanks,

Chip

it has to be LEFT JOIN, not just JOIN to work...

The other thing I find works is to put your first join in brackets:

strQ = "SELECT a_name, a_id, a.b_id, a.c_id, b.c_id, b.b_name, c.c_name FROM (a"
strQ = strQ & " INNER JOIN b"
strQ = strQ & " ON a.b_id = b.b_id)"
strQ = strQ & " INNER JOIN c"
strQ = strQ & " ON b.c_id = c.c_id;"

Adam, I tried it and it works!. I am excited...! I am making an honest effort to truly understand as much about asp as I can...

I can do easy stuff but am truly excited about learning some more.

Thanks very much.

I'm also going to try the LEFT JOIN too. I do want to learn as much as I can.

Thanks a lot.

Chip

http://www.w3schools.com/sql/sql_join.asp

JOIN syntax

Thanks Chris,

This is great! I'll put w3schools on my favorites...

Good thinking, Chip. W3Schools about the only time you'll ever see the W3 explain things in English as opposed to doublespeak.

Glad the query worked for you, too!