Posted 30 December 2005 - 11:35 PM
Table 2 has fields a,b,f,g
Table 3 has fields a,h,f
Can I join:
table1 a - table2 a,
table2 a - table3 a,
table2 f - table3 f
(This is a leaning exersize on my part, so don't kill yourself!)
I Can't figure this out. I know my query browser will allow me to make the links, but I don't really understand it well enough to use it...
BUT, I did a three table query today without JOINS, and it took FOREVER!!!
Posted 31 December 2005 - 01:00 AM
$query = mysql_query("SELECT a FROM table1 WHERE row=a'"); $valuea = mysql_result($query, 0, "a"); mysql_query("INSERT INTO table1 (a) VALUES ($valuea)"); UPDATE
This code might not work because of mysql_result but its just a quick code. Its just ideas. Hope i helped
Posted 31 December 2005 - 03:37 AM
Posted 31 December 2005 - 06:14 AM
Posted 31 December 2005 - 12:22 PM
Those links are both dead???
[!--quoteo(post=331750:date=Dec 30 2005, 10:37 PM:name=Arenium)--][div class=\'quotetop\']QUOTE(Arenium @ Dec 30 2005, 10:37 PM) [/div][div class=\'quotemain\'][!--quotec--]
My favorite intro to JOINs: [a href=\"http://hashmysql.org/index.php?title=Introduction_to_Joins\" target=\"_blank\"]Intro[/a]; [a href=\"http://hashmysql.org/index.php?title=More_Advanced_Joins\" target=\"_blank\"]More Advanced[/a]. With a little bit of knowledge you can certainly accomplish this join entirely on your own. And since this is a learning exercise, that is the idea, no?
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users