Last post Mar 21, 2014 02:04 PM by markfitzme
Mar 21, 2014 06:36 AM|vignesht5|LINK
I am using this query to fetch the details of two tables.
n.[Desc],n.[Team],h.[Size] as [Old Size],
f rom Hist as h inner join Sizing as n
on(n.CODE=h.CODE) and (n.[Name]=h.[Name]) and
(n.[Group]=h.[Group]) and (n.[Desc]=h.[Desc])
(select max(Modified_Date) as Modified_Date from Sizing b where h.CODE = b.CODE
and (b.[Name]=h.[Name]) and
(b.[Group]=h.[Group]) and (b.[Desc]=h.[Desc])
Now If I need to a specific value of a Code how can I see that. Probably I am confused how to fetch specific code and see.
Mar 21, 2014 06:42 AM|AidyF|LINK
You add it to the select;
SELECT tablealias.ColumnName, n.CODE....
or do you mean how do you read the column via code? Google for "calling sql via ado.net tutorial" for examples on how to do that.
Mar 21, 2014 02:04 PM|markfitzme|LINK
If you are looking for a specific entry, add it to your where clause such as
and n.CODE = yourValue