MySQL – Using the JOIN Operator Within a SELECT Statement
Many times while working with a MySQL database you will have data spread over multiple tables. What happens if you need to access information from multiple tables within one query? In MySQL a JOIN query is just the statement for the job. Its actually quite simple to do this. Let's work through a simple example. Suppose you were working with a website that sells flower arrangements. Lets say you have a table Read More
