Select statment using multi table

Database
Enthusiast

Select statment using multi table

Let me know which of the below format is valid in selecting records from two tables,

select (organic_name, carbon_number),
(inorgnic_name, cation, anion) from organic inner join inorganic
on organic_name = inorgnic_name

or

select a.organic_name, a.carbon_number,
b.inorgnic_name, b.cation, anion from organic a inner join inorganic b
on a.organic_name = b.inorgnic_name
2 REPLIES
Enthusiast

Re: Select statment using multi table

The IInd format is the one which i generally adopt while writting the query.
Enthusiast

Re: Select statment using multi table

I too follow the second type of format.