SELECT and desc limit 2, row jump

BEFOR

With the following select, whenever the column Mc3 contains either '0' or NULL the result actually jumps to the prior row, one higher up, where there is a numeric value, which is a surprise. How could I force the DESC limit 2 row to stay put since in need to know the actual column value, even if it is 0 or NULL?

SELECT MCID,MCName
FROM Mcd, Mcg
WHERE Mcd.Mc3=Mcg.McatID AND Mcd.Mm_ID=colname
ORDER BY Mcd.McID DESC limit 2

I'm testing with three rows in a table.
note that Mcg does not contain a 0 as I cannot enter for a row ID.

Sxooter

Can you flesh this out a bit more with:

schema (i.e. what are the column types of the fields in the tables)
data( i.e. what's in the two tables...)

BEFOR

Sxooter,

You're talking with a real novice. How do I do this?

I've found that I can use an IF statement to get this to work, not ideal, but the IF uses two SELECTS (the second SELECT /else portion would fail if not for the first SELECT, which prevents this)

Sxooter

really depends on the database.

If you're on mysql, use "desc tablename" where tablename is the name of the table to get a schema of the table. Use "select * from table" to get a dump of the data currently in it.

In Postgresql, "\d tablename" instead of desc, and the same select * from table for the data.