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 FirstS.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.NameF.CodeF.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

Suthish Nair · Answer

Am not sure I clearly understood your question... Try this SELECT F.* S.Col1 from First f INNER JOIN Second S ON f.Code=s.Code Oder by F.Code

Danish Habib · Answer

you both having the same answer  Manas you jst select the first table column but i want one column of second table too Sthish did this thanks both

Manas Mohapatra · Answer

Try like below : SELECT F.* from First F INNER JOIN Second as S ON s.Code=F.Code Oder by F.Code