Jump to content

tobifg

New Members
  • Posts

    1
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

tobifg's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. 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?
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.