simple sql question

hi, i'm a newbie and can't figure something as simple as this. I have 3 tables and i was wondering if there was a "cleaner" way of doing this..

select a.REQUEST_ID, b.PURCHASE_ORD_NUM, c.SON, b.REQUEST_STATUS, b.COMPANY_CODE, a.log

from LAS.LRT107_MOG_LOG a, LAS.LRT002_REQUEST b,
LAS.LRT250_PEND_ORD c
where a.REQUEST_ID > '200703'

and a.REQUEST_ID=b.REQUEST_ID
AND b.REQUEST_ID = C.REQUEST_ID

and b.BUSINESS_UNIT = 'P'
and a.LOG NOT LIKE '%MIGR=P%'
and a.LOG LIKE '%SOS%'
and b.RECEIPT_MODE = 'LEX'
AND b.REQUEST_STATUS LIKE '%F%'
and b.REQ_TYPE = 'CB'
and b.ACTIVITY = 'V'
and B.RECEIPT_MODE = 'LEX'

thanks! Received on Tue Aug 07 2007 - 13:19:25 CDT