Click here to Skip to main content
15,886,795 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I need to produce a load analysis report on my ticketing system. It is driven by day.

On any given day I can have Validations and credit journeys, validations alone or credit journeys alone.

If I drive by Validations I can use a left join to pick up any days that have credit journeys and to all practical purposes that is the real world probability.

However I would like to expand my query to also cover the possibility that a day might see credit journeys but no validations!

The tables are on a MySQL database and the data will take the form
T1-----T2
---  ---
A-----
B-----B
-----C
D-----
E-----E

I have looked at Union but I don't think its correct.

Any thoughts?
Posted
Updated 18-Oct-14 10:07am
v3
Comments
Maciej Los 18-Oct-14 12:09pm    
I think your question is not well-formed. How can we help you if we can't see your data, its structure, etc. Please, improve your question and provide more details.

1 solution

Hi
select * from T1
Except
select * from T2
 
Share this answer
 

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900