Watch Pre-recorded Live Shows Here
Why Join
Become a member
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
C# Corner Home
Technologies
Monthly Leaders
ASK A QUESTION
Forum guidelines
Akhter HUssain
1.2k
1.1k
67k
Customer item name display ,if item master id exit in
Apr 22 2019 9:20 AM
I have item master table in which column are (ItemCode,ItemName,Weight) and second one table is customer item table(CItemcode,CItemName,CustomerID,ItemCode),
third table is customer (CustomerID,CustomerName)
fourth table is Produce item (Prodno,Itemcode,ItemName,Weight,Orderno).
Fifth table salesorder(Ornerno,CustomerID,Qty)
Now i want when select record from Produce item table, then item code from item master table, if exit in customer item table then CItemName get display otherwise if item code of item master file does not exit in customer item table against customer then item name display from item master file.
please help me..
Reply
Answers (
4
)
I want to count records
CTE Query(common-table-expressions)