sql - oracle: can you assign an alias to the from clause? -
can assign alias clause? like: select - b "markup" retail a, cost b; edit: sorry typed out bit quick , tried simplify question point didnt make sense what im trying use aliases compare months between 2 publishing dates in same table. here's found works: select distinct to_char(months_between((select distinct pubdate books3 pubid = 2), (select distinct pubdate books3 pubid = 4)), '99.99') "answer" books3 i wanted looks this: select distinct months_between(a,b) (select distinct pubdate books3 pubid = 2 a), (select distinct pubdate books3 pubid = 4 b) but isn't working yes, oracle supports table aliases. supports as in select list not in from list: select a...