Solved

JOIN problem

Posted on 2008-10-23
11
171 Views
Last Modified: 2012-05-05
I have a problem with generating report... problem with data combination...

if i select the first option i can generate --One report
if i select the second option i can generate --Second report (inner join)

Third option none of the report will work

How can i generate both report at same time:

Is there any method that we can go to code view and edit INNER join to some other join?


0
Comment
Question by:jaisonshereen
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 5
11 Comments
 

Author Comment

by:jaisonshereen
ID: 22784685
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 22784733
can you clarify the data/tables?

maybe you don't want a JOIN, but a UNION?
0
 

Author Comment

by:jaisonshereen
ID: 22784766
Can you make out do you want me to explain?
0
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 22784792
JOIN is to "match" records, based on the criteria.

UNION is to append the 2 results
say you have 2 tables, each 10 records. a union of the 2 tables will return 20 records:

SELECT * FROM TABLE1
UNION ALL
SELECT * FROM TABLE2

a JOIN needs a matching criteria, and can, based on the data, return with the same 10+10 records from 0 to 100 rows:
0 rows if there are no matching rows
100 rows if every row matches with all the rows (ie the result is a cross matrix of the 2 tables)

in normal cases, the join will return 10 rows if all the rows match once.

0
 

Author Comment

by:jaisonshereen
ID: 22784857
This is the query
queryDetailDesc.JPG
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 22784918
so union is not what you need.

now, I don't get what you understand by:

if i select the first option i can generate --One report
  -> what do you mean exactly by  "one report" ?
  * note: the first option is the INNER JOIN, actually

if i select the second option i can generate --Second report (inner join)
  * note: the second option is the LEFT OUTER JOIN, actually

Third option none of the report will work
  -> can you clarify, please?

How can i generate both report at same time?
  -> also here, it's not clear...

sorry to ask you so many questions, but I don't get the "big picture", yet.

0
 

Author Comment

by:jaisonshereen
ID: 22785000
Np angell heard about u a lot ...


if i select the first option i can generate --One report
  -> what do you mean exactly by  "one report" ?
  * note: the first option is the INNER JOIN, actually

this report you suppose "report A"


if i select the second option i can generate --Second report (inner join)
  * note: the second option is the LEFT OUTER JOIN, actually


this report you suppose "report B"

Third option none of the report will work
  -> can you clarify, please?


this report you suppose "i cannot generate either report A or B "

How can i generate both report at same time?
 
I need to generate report A and B .. by selecting any of the option above or by editing the code
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 22785309
let me understand:
you have 1 query, and want to run 2 reports on it, "at the same time" meaning: with the same query, without modification?

then, you will have to duplicate the query, one with the LEFT JOIN (option 2), and one with the INNER JOIN (option 1)
0
 

Author Comment

by:jaisonshereen
ID: 22785374
ok

I need to generate same report with some criteria, this criteria is selected by down box and calling a query which interns call another query...

the another query is what i given here ...above in snapshot...


so if a select a value A in dropdown i can generate report A when i select the option 1 radio button which is a INNER JOIN

but if i select a value B in dropdown i can generate report B when i select the option 1 radio button which is a LEFT OUTER JOIN


I cannot creat both by selecting any of the radio buttons INNER JOIN or LEFT OUTER JOIN
0
 

Author Comment

by:jaisonshereen
ID: 22785396
Sorry typo:

but if i select a value B in dropdown i can generate report B when i select the option 2 radio button which is a LEFT OUTER JOIN
0
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 500 total points
ID: 22785635
as I said, you will need 2 queries, you cannot have it in 1 query.
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question