Problem With Query

Question

0.00/5 (No votes)

See more:

Hi,

I have 2 Queries

SQL

select Users.UserId,Users.EmpNo,EmpPayments.SalBasic from Users join EmpPayments on Users.UserId=EmpPayments.UserId where EmpPayments.MonthId=6 and EmpPayments.YearId=2010 and Users.MainContractorSw='Y' and Users.UserId=43

select Users.UserId,Users.EmpNo,EmpPayments.SalBasic from Users join EmpPayments on Users.UserId=EmpPayments.UserId where EmpPayments.MonthId=6 and EmpPayments.YearId=2010 and Users.MainContractorId=43

Now I want to use these two Queries as one query and the result should be Combined of the Individual Queries

Posted 18-Nov-10 2:47am

Vigneshb6

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Bassam Abdul-Baki · Answer 1 · 2010-11-18T03:08:00

Solution 2

So instead of "Users.MainContractorSw='Y' and Users.UserId=43" and "Users.MainContractorId=43" you want "(Users.MainContractorSw='Y' and Users.UserId=43) or (Users.MainContractorId=43)".

Posted 18-Nov-10 3:08am

Bassam Abdul-Baki

Comments

Sunasara Imdadhusen 18-Nov-10 9:17am

Good one

Sunasara Imdadhusen 18-Nov-10 9:17am

This also can give same result

Sunasara Imdadhusen 18-Nov-10 9:25am

Ok. can you tell me what it will return what should be?

Vigneshb6 18-Nov-10 9:27am

First Query Results Main Contractor Results and his salary
and the second query should return the SubContractors Results and there salaries of that particular Main Contractor. If i use the Union i will get the results. but if there are no MainContractors details in the EmpPayments table it should not display the SubContractor's Details actually i have to use this query in Crystal Report.

Vigneshb6 18-Nov-10 9:31am

Sorry i can't use intersect here

Vigneshb6 18-Nov-10 23:29pm

Hi Sunasara I solved my problem by using subqueries and Union thanx for the response.

Sunasara Imdadhusen · Answer 2 · 2010-11-18T03:08:00

Hi Vignesh,

Please use UNION to combine both result like:

SQL

select Users.UserId,Users.EmpNo,EmpPayments.SalBasic from Users join EmpPayments on Users.UserId=EmpPayments.UserId where EmpPayments.MonthId=6 and EmpPayments.YearId=2010 and Users.MainContractorSw='Y' and Users.UserId=43
UNION
select Users.UserId,Users.EmpNo,EmpPayments.SalBasic from Users join EmpPayments on Users.UserId=EmpPayments.UserId where EmpPayments.MonthId=6 and EmpPayments.YearId=2010 and Users.MainContractorId=43

Please do let me know, if you have any doubt.

Please provide "Vote":thumbsdown: if this would be helpful, and make "Accept Answer" if this would be correct answer.:rose:

Thanks,
Imdadhusen