joining multiple tables.

[duuudie]

Hi

I have two queries, very similar, and I would like to create one query out of these two. I tried to check in my little sql book how to join multiple tables but it is not explained

		$sql = @mysql_query(
 		"SELECT userstexts.textID
 		, userstexts.textTitle
	 	, userstexts.textText
 		, users.userID
 		, users.username 
 		FROM userstexts
 		INNER JOIN users 
 		ON userstexts.textID = $textID
 		AND users.userID = $memberID
 		LIMIT 1"); 
		echo mysql_error();

		
				$textinfo = @mysql_query(
 		"SELECT userstexts.textID
		, userstexts.textTitle
		, userstexts.category
		, userstexts.postedDate
		, userstexts.userID
		, categories.catName 
		FROM userstexts
		INNER JOIN categories
		ON userstexts.category = categories.catID
		WHERE userID = $memberID 
		ORDER 
		BY userstexts.postedDate DESC"); 
		echo mysql_error();

thanks a lot for your time and patience

[r937]

select userstexts.textID
     , userstexts.textTitle
     , userstexts.textText
     , userstexts.postedDate
     , userstexts.category
     , categories.catName 
     , users.userID
     , users.username 
  from userstexts
inner 
  join users 
    on userstexts.userID = users.userID
inner 
  join categories
    on userstexts.category = categories.catID
 where users.userID = $memberID     
   and userstexts.textID = $textID
order 
    by userstexts.postedDate desc

[duuudie]

Thanks a lot rudy

so if I want to join multiple tables, all I have to do is use many INNER JOIN statements. In your query, users is joined to userstexts, and then categories is joined to userstexts right?

[r937]

that is correct

[duuudie]

ok cool now I got it btw, do you have a good book that you would recommend about MySql rudy? I was thinking about getting a MySql cookbook. I reall need to improve myself in this field.

[r937]

you may find several good resources (not books) on my SQL Links page

[duuudie]

Thanks a lot rudy

you rock!