Yes. You get a full result, and the second tab of the results page (the Messages tab) contains a warning letting you know that join hints are in use.
I did some research into this "Warning":
It turns out that "join hints" are perfectly legitimate SQL. It's not something I've ever used before, but these pre-built views I'm using must have some. examle: LEFT OUTER LOOP JOIN - Causes the tables to be used in the join to be analyzed in a loop fashion (good for when one table is significantly smaller than the other) as opposed to LEFT OUTER JOIN
Both give the same results. But the user gives a hint on how the join should be approached. Other options are HASH and MERGE