Thanks David
Here is the sql statement
select itmg_nm,sub1,sub2,sub3 from table1 where ((itmg_nm > = "GNRL") and not; (itmg_nm="GNRL" and sub1 < "HIN") and not (itmg_nm="GNRL" and sub1="HIN" and; sub2 < "CLA") and not (itmg_nm="GNRL" and sub1="HIN" and sub2="CLA" and sub3 < "AAA")) and ((itmg_nm < = "HAND") and not (itmg_nm="HAND" and sub1 > "WIC") and; not (itmg_nm="HAND" and sub1="WIC" and sub2 > "JJJ"))
Is there an easier way to do this? Any help appreciated.
Thanks
Darren
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only