Hi, I have columns
First name | last name | nr (individual number) | pref1 (preference1) | pref2 (preference2)| pref3(preference3) | situation | distance | sex
with 100 records in one table ap
SELECT DISTINCT nr FROM ap
First I have to display all records:
WHERE sex='F' and pref1='1' ORDER BY situation DESC, distance DESC
AND WHERE (sex='F' and pref2='1' and situation= ' ' ) ORDER BY distance DESC
and WHERE (sex='F' and pref3='1' and situation= ' ' ) ORDER BY distance DESC
LIMIT 4
Then I would like to join results from:
WHERE sex='M' and pref1='1' ORDER BY situation DESC, distance DESC
AND WHERE (sex='M' and pref2='1' and situation= ' ' ) ORDER BY distance DESC
AND WHERE (sex='M' and pref3='1' and situation= ' ' ) ORDER BY distance DESC
LIMIT 7
and then join to all records from:
WHERE sex='F' and pref1='2' ORDER BY situation DESC, distance DESC
AND WHERE (sex='F' and pref2='2' and situation= ' ' ) ORDER BY distance DESC
AND WHERE (sex='F' and pref3='2' and situation= ' ' ) ORDER BY distance DESC
LIMIT 10
and so on...
In the results of all I can't have redundancies. It means when in first group of result I get individual number (column "nr") of '2112' it can't be displayed in last one of results.
Is it possible to do?