Can't write this SQL.

[Anon]

I want to take specific columns from my login table and JOIN them with specific columns from my test table. So far I cannot construct the proper SQL statement. I keep getting mySQL errors.

$result3 = mysql_query( "SELECT login.firstname, login.lastname FROM login JOIN test.questionone, test.questiontwo, test.questionthree ON test.id = login.id WHERE test.registration = '34568uit'" );

Doesn't work.

$result3 = mysql_query( "SELECT login.firstname, login.lastname FROM login AS C JOIN test.questionone, test.questiontwo, test.questionthree as O ON test.id = login.id WHERE test.registration = 'lovenox01'" );

Doesn't work.

I am constucting this just as my mySQL book says but it will not work.

[Anon]

This SQL had the desired effect. Join wasn't even needed.

$result3 = mysql_query( "SELECT login.firstname, login.lastname, test.questionone, test.questiontwo, test.questionthree, test.questionfour, test.questionfive, test.questionsix, test.questionseven, test.questioneight, test.questionnine, test.questionten, test.questioneleven, test.questiontwelve, test.totalscore FROM login ,test WHERE login.registration = '45rt6n2' AND test.id = login.id GROUP BY login.lastname" );

[[deleted]]

That IS a join, only in a different syntax.

[Anon]

I guess it is a join. Columns from two tables being put together.

Thanks.