Sorry for repeating the question, but I've got this problem .....
I need to extract as follows:
1.
SELECT * FROM WYISORG WHERE etc. etc.
and
2.
SELECT * FROM WYISORG, WYISCONTACT WHERE
etc. etc.
Basically query 1 is simply from one table, whereas query 2 uses criteria in the second table. Both extract exactly the same data.
Then I need to put the two lots of results together and make sure they are unique.
Should I use a temporary table? and how? and how would I make sure each user got a different answer?
or
Can I combine the two queries with some sort of outer join?
Thanks folks!
I need to extract as follows:
1.
SELECT * FROM WYISORG WHERE etc. etc.
and
2.
SELECT * FROM WYISORG, WYISCONTACT WHERE
etc. etc.
Basically query 1 is simply from one table, whereas query 2 uses criteria in the second table. Both extract exactly the same data.
Then I need to put the two lots of results together and make sure they are unique.
Should I use a temporary table? and how? and how would I make sure each user got a different answer?
or
Can I combine the two queries with some sort of outer join?
Thanks folks!