Joining Query problem

Question

I want to join 2 tabls with id. I wrote following query but i am getting an error. I want to select all columns simultaneously in mysql.

select t1.* t2.* table1t1 
  JOIN table2t2 
    ON t1.id = t2.postads_id 
where ads_id=1277719543 
  AND email='[email protected]';

ERROR: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 't1 JOIN nextpostads t2 ON t1.id = t2.postads_id where ads_id=1277719543 AND emai' at line 1

what modification is needed ?

Answer 1

There is a comma missing between t1.* and t2.* and there is no FROM clause:

SELECT t1.*, t2.*
  FROM table1 t1 
  JOIN table2 t2 
    ON t1.id = t2.postads_id 
 WHERE ads_id = 1277719543 
   AND email = '[email protected]'

Also, try sticking to either uppercase of all keywords or lowercase, but not mixing it.

Answer 2

You are missing the FROM in your statement. Try:

select t1.*, t2.* 
FROM table1 t1 
  JOIN table2 t2 
    ON t1.id = t2.postads_id 
where ads_id=1277719543 
  AND email='[email protected]';

Answer 3

select t1.*, t2.* FROM table1 t1 
  JOIN table2 t2 
    ON t1.id = t2.postads_id 
where t1.ads_id=1277719543 
  AND t1.email='[email protected]';