Meaning of DistinctRow in this context?

DELETE 
        DISTINCTROW tbl1.*, tbl2.Name
    FROM 
        tbl1 INNER JOIN tbl2 ON tbl1.EMP_NUM = tbl2.EMP_NUM
    WHERE 
        (((tbl2.Name) Not Like [Forms]![formReports]![txtName]));

I just need to verify that my description below makes sense or if it doesn't point out why and what the statement actually does. Here is what I think it does:

Join the tables using the EMP_NUM and delete the duplicate records based on the name being different from that entered into the view "txtName" on the form "formReports."

OR

Does it delete all values from the columns in tbl1 and only the values in the field Name in tbl2 where the name entered into the form is different from that in tbl2.

Any thoughts?

Answers


Because you are joining two tables and have fields from both tables, the DISTINCTROW is not doing anything.

You can see the documentation here that explicitly spells this out.


Need Your Help

range jquery ui slider to fit a predertermined value (total numer of seats)

jquery jquery-ui jquery-slider

I'm making an application to reserve seats on a train, but i need to discriminate between children and grown-ups, so i have settled two jquery-ui sliders (each one bound to a form element) the prob...

I need to show excel data on a presentable web page or word doc?

sql xml excel xhtml formatting

I have survey results which are formatted in excel fine. I then need to show these results indivually wiht the headings on a presentable word doc or wewb page? s there any weay to do this.

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.