luma luma - 2 years ago 184
SQL Question

Is there any term like 'DOT(.) notation' used in SQL joins?

Is there any term like 'DOT(.) notation' used in SQL joins?
if practised, pls explain how to use it.

Thanks in advance.

Answer Source

Yes here is how you do it

When you do your SELECT

SELECT firstname, lastname from dbo.names n -- The n becomes an alias JOIN address a --- another alias

on a.userid = n.userid
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download