Query

Question

I want to get the data from two tables from one table i want to get all the data and from second table i want just one column i have a relationship between the tables 

 

SELECT * from First,S.CodeName

INNER JOIN second AS S on Second.RID=First.RId

 

 

1-one way is to get all the columns from first table by name to name like i have to include all the columns just like that

SELECT F.Name,F.Code,F.Date from First

INNER JOIN Second as S ON s.Code=F.Code

Oder by F.Code

 

 

---This works fine but i want to know other way how to used Select * and a specific column in one query please assists