SqlDataSource not working

See more:

ASP.NET

select pmtblempreg.Id,pmtblempreg.Name,pmtblempreg.UserName,pmtbldesignation.Designation, pmtblempreg.skypeid,pmtblempreg.EmailId from pmtbldesignation
right join pmtblempreg  on pmtbldesignation.Id=pmtblempreg.DesignationId

This query works fine in oracle database.... But when executing using sqlDataSource for populating a gridview an error is showing that invalid table name

when i execute it through the query builder of sqldataSource the query changes to

SELECT        PMTBLEMPREG.ID, PMTBLEMPREG.NAME, PMTBLEMPREG.USERNAME, PMTBLDESIGNATION.DESIGNATION, PMTBLEMPREG.SKYPEID,
                         PMTBLEMPREG.EMAILID
FROM            { oj PMTBLDESIGNATION RIGHT OUTER JOIN
                         PMTBLEMPREG ON PMTBLDESIGNATION.ID = PMTBLEMPREG.DESIGNATIONID }

an oj is automatically created along with the table name.... Is that the problem??