The
dot (.) is used to separate database name, table name and column name when we
use JOINs. The simple example is
select cust.customer_name, sum (detail.total_spend) as total_spend from
customers as cust inner join sales as detail
on cust.customer_id=detail.customer_id
group by cust.customer_name
select cust.customer_name, sum (detail.total_spend) as total_spend from
customers as cust inner join sales as detail
on cust.customer_id=detail.customer_id
group by cust.customer_name
Ø
When
a single dot is used, by default the current user is considered so it becomes
username.tablename.
Ø
When
two dots are used, by default the current database and user are considered so it
becomes dbname.username.tablename.
Ø
When
three dots are used, by default the current server, database and user are
considered so it becomes servername.dbname.username.tablename
Select * from . Customers
select * from .. Customers
select * from … customers
select * from .. Customers
select * from … customers
No comments:
Post a Comment
If you have any doubt, please let me know.