MULTIPLE SELECTS OF DATA

Anon · 2000-12-05T14:13:28+00:00

Here's what I need to do with Mysql SELECT data from one table using one set of criteria SELECT some more data from the same table using another set of cri...

MULTIPLE SELECTS OF DATA

Anon

Here's what I need to do with Mysql

SELECT data from one table using one set of criteria
SELECT some more data from the same table using another set of criteria
Make sure that records are not duplicated

Therefore I need to do the select query, put the data in a temporary table, do the next select query and add the data to the temporary table.

Trouble is, I haven't a clue how to create the temporary table!

Is this the best way to solve this anyway?

Thanks

Elizabeth Alderton

Anon

If all the records are coming from the same table there is no need for a temp table.

select distinct(unique_identifier),other,fields,to,select from table_name where (first set of criteria) or (second set of criteria)

Anon

Dear Rod

Thanks for that - and I think I can do it in one query. However, I need an outer join and the code isn't working

here it is:

"SELECT d.* FROM WYISORG AS d, WYISCONTACT AS d1 "
"LEFT OUTER JOIN d1 ON d.ORGID=d1.ORGID "
"WHERE "
(d1.SURNAME LIKE '%$searchphrase%')
OR (d.ORGANIZATIONNAME LIKE '%$searchphrase%')";
OR (d.BRIEF LIKE '%$searchphrase%')";
ORDER BY d.ORGANIZATIONNAME";

and this produces no records.

I hope I've got it right that even if nothing matches in WYISCONTACT it should still produce the records

Thanks again.