I've got a statement as follows that grabs matching records out two tables:
"SELECT * FROM BKRETAIL WHERE BKRETAIL.MATK='THISTHE' UNION SELECT * FROM BKMASTER WHERE BKMASTER.MATK='THISTHE';
My problem is that when I try to place something like "ORDER BY BKRETAIL.MEDSTA ASC" after the statement, it throws an error. I need these ordered in a certain arrangement. To be honest, what I really need is to order them by when MEDSTA's field is "RT" first, then "LW", then "OE", then null... but I haven't been able to figure out how to do that so I just put in an "ORDER BY" so the nulls would at least be at the end... Can anybody help me figure out how to order this list?? Thanks BUNDLES
|