Hello,
Is there a way to concatenate two queries into one statement?
I have 2 queries with the same field, but one selects records from all types that are not ="R" and the second selects all from a single specified type = "R":
select fld1 from tbl1 where fldType !="R";
select fld1 from tbl1 where fldType ="R";
(I'm not sure if ! or Not is appropriate here?????)
I would like to join these two into one query. The reason for doing this is so that fields with type ="R" will be listed after those that are not ="R". Type "R" are less important so I would like them listed last. Sort by fldType doesn't help because it sorts fldType alphabetically and doesn't necessarily list type "R" last.
I haven't included the queries because they're long. If needed I can do so. I appreciate any ideas.
Is there a way to concatenate two queries into one statement?
I have 2 queries with the same field, but one selects records from all types that are not ="R" and the second selects all from a single specified type = "R":
select fld1 from tbl1 where fldType !="R";
select fld1 from tbl1 where fldType ="R";
(I'm not sure if ! or Not is appropriate here?????)
I would like to join these two into one query. The reason for doing this is so that fields with type ="R" will be listed after those that are not ="R". Type "R" are less important so I would like them listed last. Sort by fldType doesn't help because it sorts fldType alphabetically and doesn't necessarily list type "R" last.
I haven't included the queries because they're long. If needed I can do so. I appreciate any ideas.