mysql select query

[safra]

Hi,

I have a table with among others columns 'sGroup', 'sID'.

How can I search the table on something but instead of returning a row that matches the query, return the row that has the same value for sGroup value 0 for column 'sID'.

example:

row 1:
sGroup = 12
sID = 0

row 2:
sGroup = 12
sID = 4

row 2 matches the search criteria on other columns but has value 4 in column sID. This row should not be included in the results but instead row 1 should be included because it has the same sGroup value and value 0 for column sID.

I know this can be regarded as bad database design but is it possible to make a query that returns the correct rows?

Thanks,

Raoul

[nemonoman]

Can you be more clear with your question?

Sounds like you just want to add another element to your
SELECT? Don't select row if Sid greater than 0

SELECT *
FROM myTable
WHERE sGroup = 12
AND sID = 0

[safra]

Sorry for the misunderstanding. The real search criteria come from a form. But instead of showing the rows that match this criteria I would like to show the row that has the same value for sGroup and value 0 for sID for those rows that match the search criteria.

I found that something like this works:

SELECT t1.* FROM table1 t1, table1 t2 WHERE m.fname='$forumname' AND d.fname='$forumname' AND t1.sGroup=t2.sGroup AND t1.sID='0' AND <form search criteria> GROUP BY t1.sGroup

Raoul