Tips on joining/searching tables - MySQL

[eluser]andriu[/eluser]
Hi everyone!

Does any one have some tips on joining tables or possible any good
tutorials or articles on mysql searching and joining??

Need to done some (for me advanced searches)..

I've searched around a bit but found it hard to find good resources..

Thanks

[eluser]danmontgomery[/eluser]
[quote author="andriu" date="1267047011"]I've searched around a bit but found it hard to find good resources..[/quote]

This might be because what you're looking for is incredibly vague...

http://dev.mysql.com/doc/refman/5.1/en/f...earch.html
http://dev.mysql.com/doc/refman/5.1/en/join.html
http://dev.mysql.com/doc/refman/5.1/en/s...gines.html

[eluser]omick[/eluser]
my tip is do some reading on SQL... familiarize yourself with types of joins inner, outer, left, right, full ... some books covers relational algebra and if you could understand and master it very well then joining tables would be much easier.. you should also try those examples on your choice of rdbms(mysql, postgre, oracle) because some of them might syntactically different but all of them are semantically the same... specific functions and storage engines of any rdbms greatly affects the performance of your query.

[eluser]andriu[/eluser]
Thanks for the input guys!