Is it possible to combine the following two queies to one

[bosky]

Hi There!


I have 2 queries, each selecting set of records from different tables.

SELECT Distinct(parent_ID) FROM item_audits WHERE created>=date OR edited>=date

SELECT Distinct(parent_ID) FROM item_responses WHERE created>=date

Now i want to combine the above 2 queries to one query.is it possible?

NOTE: all the refered fields are of datetime type

Regards
Bosky

 

[LittleSmudge]

I think what you mean is


SELECT DISTINCT Parent_Id FROM (
SELECT parent_ID FROM item_audits WHERE created >= date OR edited >= date
UNION
SELECT parent_ID FROM item_responses WHERE created >= date );



'ope-that-'elps.





G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.

 

[bosky]

Thanks for ur reply.

The statement fetches the result i want when i remove the line
"SELECT DISTINCT Parent_Id FROM (" From the above statement.


Thanks a lot.

 

[LittleSmudge]

Arrrh.

But if the two separate SELECTS yield the same ParentId then you'll get a duplicate in the result.

You need to add the Distinct to DeDup the combined dynaset.

-or can't they yield matching ParentId values anyway ?





G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.

 

[swampBoogie]

But if the two separate SELECTS yield the same ParentId then you'll get a duplicate in the result.

No, union removes duplicates.

 

[bosky]

When i use the Distinct Clause it gives me a syntax error, Is there a different way to write the Disticnt clause in MySQL.