SQLSERVER - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

SQLSERVER

Author

Topic

minnu
Starting Member

1 Post

Posted - 2008-05-23 : 03:04:50

HI FRIENDS MAY U HELP ME TO SLOVE THIS ISSUE

MY TABLES ARE COR_FIELD AND ADTL_INFO

IN COR_FIELD I HAVE

FIELD_ID FIELD_LABEL
109 GLAZE
120 FINISH
130 DRAWER

AND IN TABLE ADTL_INFO FIELDS ARE
SALES_ORDER_ID FIELD_ID FIELD_VALUE
1 109 NULL
1 120 MAHESH
1 130 RAJESH
2 109 MINNU
2 120 SRINIVAS
2 130 SHIVA

THE QUESTION IS HOW TO SELECT INDIVIDUAL FIELD VALUE FOR ONE PARTICULAR SALES_ORDER

mahi

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-05-23 : 03:11:19

quote:
Originally posted by minnu

THE QUESTION IS HOW TO SELECT INDIVIDUAL FIELD VALUE FOR ONE PARTICULAR SALES_ORDER

SELECT FIELD_ID, FIELD_VALUE FROM ADTL_INFO WHERE SALES_ORDER_ID = 2

E 12°55'05.25"
N 56°04'39.16"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources