I have a simple task in MySQL. I have two tables t1 and t2. Table t1 has one column in common with table t2. 
What I want is to return all the columns from both tables (order is not important) but making sure that the rows of both tables are matching based on a common field, say fieldx. However, not all the rows in table t1 have a matching row in table t2 (i.e. table t1 has much more rows, but all rows in t2 have a matching row in t1 ).

I tried to use `where` as such:

`SELECT t1.* t2.* from t1, t2 where t1.fieldx=t2fieldx`

However this returns only the number of rows as there are in table t2.

I also tried right and left joins, but couldn't get that to work either (this way not all columns of both tables were included..)

How would I do this?