left join not working
hye i tried below query in mysql and SQL server databases its working fine, so please check once again. and tell me which database u tried.

SELECT t1.id, t2.value
FROM table1 t1
LEFT JOIN table2 t2
    ON t2.id = t1.id

id   value  
--  --------
 1       100
 2       200
 3    (NULL)
 4    (NULL)


Thanks.