Click here to Skip to main content

khan2010 - Professional Profile

Summary

143
Authority
-323
Debator
10
Enquirer
17
Organiser
133
Participant
0
Author
0
Editor
No Biography provided
Member since Tuesday, May 15, 2007 (6 years, 1 month)

Contributions

Articles 0
Tech Blogs 0
Messages 18 (Under Water)
Q&A Questions 1
Q&A Answers 8
Tips/Tricks 0
Comments 4

Links

Reputation

For more information on Reputation please see the FAQ.

Privileges

Members need to achieve at least one of the given member levels in the given reputation categories in order to perform a given action. For example, to store personal files in your account area you will need to achieve Platinum level in either the Author or Authority category. The "If Owner" column means that owners of an item automatically have the privilege, and the given member types also gain the privilege regardless of their reputation level.

ActionAuthorAuthorityDebatorEditorEnquirerOrganiserParticipantIf OwnerMember Types
Have no restrictions on voting frequencysilversilversilversilverAdmin
Store personal files in your account areaplatinumplatinumSitebuilder, Subeditor, Supporter, Editor, Staff
Have live hyperlinks in your biographybronzebronzebronzebronzebronzebronzesilverSubeditor, Protector, Editor, Staff, Admin
Edit a Question in Q&AsilversilversilversilverYesSubeditor, Protector, Editor, Admin
Edit an Answer in Q&AsilversilversilversilverYesSubeditor, Protector, Editor, Admin
Delete a Question in Q&AYesSubeditor, Protector, Editor, Admin
Delete an Answer in Q&AYesSubeditor, Protector, Editor, Admin
Report an Articlesilversilversilversilver
Approve/Disapprove a pending ArticlegoldgoldgoldgoldSubeditor, Mentor, Protector, Editor, Staff, Admin
Edit other members' articlesSubeditor, Protector, Editor, Admin
Create an article without requiring moderationplatinumSubeditor, Mentor, Protector, Editor, Staff, Admin
Report a forum messagesilversilverbronzeProtector, Editor, Admin
Create a new tagsilversilversilversilverAdmin
Modify a tagsilversilversilversilverAdmin

Actions with a green tick can be performed by this member.


 
You must Sign In to use this message board.
Search this forum  
QuestionWhat Query i have to used Pin
Wednesday, October 21, 2009 1:50am by khan786
I have 4 tabel
 
table 1 have productname
abc_123a
cfl_523j
jpm_111k
 
table 2 have productname - purqty
abc_123a - 50
abc_123a - 30
cfl_523j - 100
cfl_523j - 20
cfl_523j - 10
jpm_111k - 105
jpm_111k - 10
jpm_111k - 25
 
table 3 have productname - soldqty
abc_123a - 10
abc_123a - 05
cfl_523j - 20
cfl_523j - 05
cfl_523j - 10
jpm_111k - 15
jpm_111k - 05
jpm_111k - 10
 
table 4 have productname - refqty
abc_123a - 2
abc_123a - 6
cfl_523j - 4
cfl_523j - 3
cfl_523j - 9
jpm_111k - 3
jpm_111k - 8
jpm_111k - 2
 
Out put i want is
 
productname - purqty - soldqty - refqty - STOCK
abc_123a - 80 - 15 - 8 - 57
cfl_523j - 130 - 35 - 16 - 79
jpm_111k - 140 - 30 - 13 - 97

 
HOW CAN I DO THIS USING SQL QUERY
PLZ REPLY
Thanks in advance
CrystalTech

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   


Advertise | Privacy | Mobile
Web04 | 2.6.130617.1 | Last Updated 19 Jun 2013
Copyright © CodeProject, 1999-2013
All Rights Reserved. Terms of Use
Layout: fixed | fluid