A、It can be used to join a maximum of three tables 

B、It can be used to restrict the number of columns used in a NATURAL join 

C、It can be used to access data from tables through equijoins as well as nonequijoins 

D、It can be used to join tables that have columns with the same name and compatible data types